HIVE-20593 is fixed in Hive Opensource community, I am suspecting implementing this code fix in your current cluster will help to resolve your issue. You can contact hortonworks support to validate my suspect & get hotfix. ... View more

Suspecting HIVE-20593 should help to fix this issue. ... View more

To see all values of a session in 1)HS2 beeline --outputformat=tsv2 -u '<HS2_JDBC_URL> -e 'set -v' > session.txt 2) Cli hive --outputformat=tsv2 -e 'set -v' > session.txt If specific key to be searched, then after launching beeline or cli, use the specific keys as below beeline> set hive.exec.dynamic.partition.mode; If my suggestion helped to resolve your query, accept the answer. It might help others in the community. ... View more

Glad to hear that the issue is resolved. You can either create local folder & give permissions or Hive will create hive.exec.local.scratchdir & provide permissions as configured in hive.scratch.dir.permission Provided if the user is having privileges on parent directory. If my answer helped to resolve the issue, accept the answer. It might help others in the community. ... View more

This issue is happening because user infa does not have privilege to create local directory in /tmp/ You can launch hive with custom local directory which might have privileges for infa user. hive --hiveconf hive.exec.local.scratchdir=<local machine path> ... View more

When applying order by twice, hive assumes column selection order is same on both inner & outer query which does order by on wrong column assuming wrong column datatype. You can rewrite your query having outer & inner query projection as same. SELECT t_6.color color, t_6.noq_empty noq_empty FROM (SELECT t_5.color_gbakc2 color, t_5.noq_empty_gbakc3 noq_empty FROM (SELECT testtable.color_gbakc2 color_gbakc2, testtable.noq_empty_gbakc3 noq_empty_gbakc3, testtable.color_gbakc1 color_gbakc1 FROM testtable testtable WHERE testtable.color_gbakc2 IN ('Red', 'Blue', 'Green') ) t_5 WHERE t_5.color_gbakc2 IN ('Red', 'Blue') ORDER BY noq_empty ASC ) t_6 ORDER BY color Fortunately HIVE-6348 is a plan optimizer & its eliminating this issue also. If my answer helped you, accept the answer. It will help others in the community. ... View more

Statistics estimation is approximated based on available stats. In your case, i see basic stats are collected, but column stats are not collected. To estimate the number of distinct values for a column, can you run analyze table temp.test_distinct compute statistics for columns; and check explain plan. ... View more