Re: spark sql - group by constant column

2015-07-15 Thread Lior Chaga
I found out the problem. Grouping by a constant column value is indeed impossible. The reason it was working in my project is that I gave the constant column an alias that exists in the schema of the dataframe. The dataframe contained a data_timestamp representing an hour, and I added to the

spark sql - group by constant column

2015-07-15 Thread Lior Chaga
Hi, Facing a bug with group by in SparkSQL (version 1.4). Registered a JavaRDD with object containing integer fields as a table. Then I'm trying to do a group by, with a constant value in the group by fields: SELECT primary_one, primary_two, 10 as num, SUM(measure) as total_measures FROM tbl