My spark sql query is
sqlContext.sql( """select b.*, count(*) AS CNT from tableb b GROUP BY b.Key,b.KeyVal CLUSTER BY b.Key,b.KeyVal """)
Error is
Exception in thread "main" java.lang.RuntimeException: [5.7] failure: ``union'' expected but identifier CLUSTER found CLUSTER BY b.Key