org.apache.hive.service.cli.HiveSQLException: Error while processing statement: Cannot modify resultset.use.unique.column.names at runtime. It is not in list of params that are allowed to be modified at runtime org.apache.hive.service.cli.HiveSQLException: Error while processing statement: Cannot modify groupby.orderby.position.alias at runtime. It is not in list of params that are allowed to be modified at runtimeThe following are the set properties:
hive.groupby.orderby.position.alias = true hive.resultset.use.unique.column.names = false
hive.hive.groupby.orderby.position.alias = true hive.hive.resultset.use.unique.column.names = false
Hi Sindhu: Thanks for your post above, which may be relevant to a problem I am having with Tableau - I have two dev. boxes - I can connect to the Hortonworks Sandbox on one machine with no problems, but not on the other. You state above "To resolve this issue, set the properties like hive.hive in Tableau". My question: how do I do that from Tableau? Thanks for pointing me in the right direction, and best wishes, Michael Martin
Ambari Hive View pages are not rendered in Microsoft Internet Explorer 11
ISSUE: Empty rows in the Beeline output even with "--silent=true" option
Unable to create Hive table with column names starting with a '/'
Hiveserver2 services crashes at memcpy of native frame and SIGSEGV
How to enable debug HIVE CLI logging?
Hive table displays junk characters when UTF-8 data is inserted to the table
Unable to generate hive-log4j.properties file on nodes on which the Hiveserver2 is installed.
This website uses cookies for analytics, personalisation and advertising. To learn more or change your cookie settings, please read our Cookie Policy. By continuing to browse, you agree to our use of cookies.
HCC Guidelines | HCC FAQs | HCC Privacy Policy | Privacy Policy | Terms of Service
© 2011-2019 Hortonworks Inc. All Rights Reserved.
Hadoop, Falcon, Atlas, Sqoop, Flume, Kafka, Pig, Hive, HBase, Accumulo, Storm, Solr, Spark, Ranger, Knox, Ambari, ZooKeeper, Oozie and the Hadoop elephant logo are trademarks of the Apache Software Foundation.