In Hive how to do collect_list(path) in ascending order based on servicetime column grouping by service_date,timeslot,customer_id,category,product,sub_product. Path order is correct when the select query is executed. Correct Answer Hive Query ->
select sum(calls),concat_ws(':',collect_list(path)) FROM test group by service_date,timeslot,customer_id,category,product,sub_product;
Output : 38,|MN_0038|MN_0008|MN_0003|MN_0002|MN_0001|Dummy:|MN_0003|MN_0002:|MN_0001|Dummy:|MN_0001|Dummy But when I execute on 1 gb of data for bulk aggregation from one table to another table the order of path is not correct. Wrong Answer Hive Query ->
with isort as select calls,path from raw_test order by servicetime asc)
from isort
insert into table test
select sum(calls),concat_ws(':',collect_list(path)) FROM test group by service_date,timeslot,customer_id,category,product,sub_product;
Output : 38,|MN_0003|MN_0002:|MN_0001|Dummy:|MN_0038|MN_0008|MN_0003|MN_0002|MN_0001|Dummy:|MN_0001|Dummy Like Mysql am trying to write hive query with order by clause am facing an error Error Hive Query like MySQL ->
with isort as ( select calls,path from raw_test order by servicetime asc)
from isort
insert into table test
select sum(calls),concat_ws(':',collect_list(path)) FROM test group by service_date,timeslot,customer_id,category,product,sub_product order by servicetime;
... View more
