Hi,
I am using Spark 1.1.0. I have the following SQL statement where I am trying
to count the number of UIDs that are in the "tusers" table but not in the
"device" table.
val users_with_no_device = sql_cxt.sql("SELECT COUNT (u_uid) FROM tusers
WHERE tusers.u_uid NOT IN (SELECT d_uid FROM device)")
I am getting the following error:
Exception in thread "main" java.lang.RuntimeException: [1.61] failure:
string literal expected
SELECT COUNT (u_uid) FROM tusers WHERE tusers.u_uid NOT IN (SELECT d_uid
FROM device)
I am not sure if every subquery has to be a string, so I tried to enclose
the subquery as a string literal as follows:
val users_with_no_device = sql_cxt.sql("SELECT COUNT (u_uid) FROM tusers
WHERE tusers.u_uid NOT IN ("SELECT d_uid FROM device")")
But that resulted in a compilation error.
What is the right way to frame the above query in Spark SQL?
thanks
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/SparkSQL-Nested-Query-error-tp17691.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
For additional commands, e-mail: user-h...@spark.apache.org
