You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by Linyuxin <li...@huawei.com> on 2016/07/21 07:20:04 UTC
Where is the SparkSQL Specification?
Hi All
Newbee here.
My spark version is 1.5.1
And I want to know how can I find the Specification of Spark SQL to find out that if it is supported ‘a like %b_xx’ or other sql syntax
Re: Where is the SparkSQL Specification?
Posted by Mich Talebzadeh <mi...@gmail.com>.
Spark SQL is a subset of Hive SQL which by and large supports ANSI 92 SQL
including search parameters like above
scala> sqlContext.sql("select count(1) from oraclehadoop.channels where
channel_desc like ' %b_xx%'").show
+---+
|_c0|
+---+
| 0|
+---+
So check Hive QL Language support
HTH
Dr Mich Talebzadeh
LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.
On 21 July 2016 at 08:20, Linyuxin <li...@huawei.com> wrote:
> Hi All
>
> Newbee here.
>
> My spark version is 1.5.1
>
>
>
> And I want to know how can I find the Specification of Spark SQL to find
> out that if it is supported ‘a like %b_xx’ or other sql syntax
>