To get Hive query from timeline server

Hi all, I am working on a Dashboard project, to list all the Hive jobs submitted in the Yarn and all the other related details like No. of Mappers, No. of reducers etc., Is there any chance to get the Hive query(complete query) from the Time line server ? Regards, Raghu M

Efficiency of too many grouping sets

Dears, I had taken a SELECT script with 90 sets in one GROUPING, and there was a serious data skewing problem. Was it concerned with the too many GROUPING SETS and how to solve it? ( I couldn't simply set hive.groupby.skewindata to true because there were some COUNT(DISTINCT ...) in i

SCRATCH directories renaming on S3 on hive table taking too much time.

Hi everyone I am running PIG Store command to write to a HIVE table(external table with location on S3) using "HCatStorer" on AWS EMR. The pig command looks like this: STORE return_data INTO 'TABLE_NAME' USING org.apache.hive.hcatalog.pig.HCatStorer('part_column=20180910'); I have already set i