supported sql functions

[Srinivas Chamarthi <sr...@gmail.com>]

can anyone point me to a documentation on supported sql functions ? I am
trying to do a contians operation on sql array type. But I don't know how
to type the  sql.

// like hive function array_contains
select * from business where array_contains(type, "insurance")



appreciate any help.

Re: supported sql functions

[Akhil Das <ak...@sigmoidanalytics.com>]

These are the feature list
<http://spark.apache.org/docs/1.1.0/sql-programming-guide.html#compatibility-with-apache-hive>
available i believe. You can create a custom udf for the contains. A
similar example is explained on this StackOverflow
<http://stackoverflow.com/questions/25031129/creating-user-defined-function-in-spark-sql>
post

Thanks
Best Regards

On Sun, Nov 9, 2014 at 7:27 PM, Srinivas Chamarthi <
srinivas.chamarthi@gmail.com> wrote:

> can anyone point me to a documentation on supported sql functions ? I am
> trying to do a contians operation on sql array type. But I don't know how
> to type the  sql.
>
> // like hive function array_contains
> select * from business where array_contains(type, "insurance")
>
>
>
> appreciate any help.
>
>

Re: supported sql functions

[Nicholas Chammas <ni...@gmail.com>]

http://spark.apache.org/docs/latest/sql-programming-guide.html#supported-hive-features

2014년 11월 9일 일요일, Srinivas Chamarthi<sr...@gmail.com>님이 작성한
메시지:

> can anyone point me to a documentation on supported sql functions ? I am
> trying to do a contians operation on sql array type. But I don't know how
> to type the  sql.
>
> // like hive function array_contains
> select * from business where array_contains(type, "insurance")
>
>
>
> appreciate any help.
>
>