subject:"Restrictions on SQL operations on Spark temporary tables"

Re: Restrictions on SQL operations on Spark temporary tables

2016-02-27 Thread 刘虓

Hi, For now Spark-sql does not support subquery,I guess that's the reason your query fails 2016-02-27 20:01 GMT+08:00 Mich Talebzadeh : > It appeas that certain SQL on Spark temporary tables do not support Hive > SQL even when they are using HiveContext > > example > >

Restrictions on SQL operations on Spark temporary tables

2016-02-27 Thread Mich Talebzadeh

It appeas that certain SQL on Spark temporary tables do not support Hive SQL even when they are using HiveContext example scala> HiveContext.sql("select count(1) from tmp where ID in (select max(id) from tmp)") org.apache.spark.sql.AnalysisException: Unsupported language features in query: