Outlier Detection in SQL
periscopedata.com
Outlier Detection in SQL
1–10 of 36 posts
Re: Outlier Detection in SQL
#2More please.
Re: Outlier Detection in SQL
#3Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that.
Also, none of those queries will work on MySQL.
Re: Outlier Detection in SQL
#4Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that. Also, none of those queries will work on MySQL.
I recognize the syntax in "date_trunc('day', created_at)::date as day,", namely the cast "::date", as PostgreSQL syntax.
Could be something else as well but I've only seen it with PostgreSQL.
Re: Outlier Detection in SQL
#5Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that. Also, none of those queries will work on MySQL.
It's redshift, based on the contents of previous blogs.
Re: Outlier Detection in SQL
#6Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that. Also, none of those queries will work on MySQL.
The examples are either PostgreSQL or Amazon Redshift (which is based on the same syntax).
Re: Outlier Detection in SQL
#7Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that. Also, none of those queries will work on MySQL.
PostgreSQL or its derivatives.
The code would work on most engines that support CTEs, with some changes to the type casting syntax.
Thus most except MySQL.
Re: Outlier Detection in SQL
#8Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that. Also, none of those queries will work on MySQL.
They support Postgres, Microsoft SQL Server, Redshift, and Oracle I believe.
Re: Outlier Detection in SQL
#9Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that. Also, none of those queries will work on MySQL.
They support Postgres, Microsoft SQL Server, Redshift, and Oracle I believe.
That's useful info, I may sign up for a demo then.
Re: Outlier Detection in SQL
#10Is it just me or is Periscope allergic to saying what databases it supports? I can find nothing on the website, and I am really hesitant to sign up for more info once companies started actually calling my phone after I did that. Also, none of those queries will work on MySQL.
They support Postgres, Microsoft SQL Server, Redshift, and Oracle I believe.
They also support MySQL. At least they did when I tired it some time ago.