Member since
03-23-2015
1288
Posts
114
Kudos Received
98
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 4350 | 06-11-2020 02:45 PM | |
| 5956 | 05-01-2020 12:23 AM | |
| 3777 | 04-21-2020 03:38 PM | |
| 4050 | 04-14-2020 12:26 AM | |
| 3028 | 02-27-2020 05:51 PM |
09-21-2018
03:16 AM
This is not supported, you just need to call execute() for each query.
... View more
09-20-2018
11:12 PM
2 Kudos
Then you will need to load the schema for Hive to read, they are under https://github.com/apache/hive/tree/master/metastore/scripts/upgrade Go into the database type directory and locate the version of your Hive, for example: https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/mysql/hive-schema-2.0.0.mysql.sql You will need to load it into your database. If you are using Cloudera Manager, go to CM > Hive > Action > Create Hive MetaStore Database Tables Then you should be good.
... View more
09-20-2018
03:56 PM
Please try one of below: 1. in beeline run: !connect 'jdbc:hive2://server1.abc.com:10000/default' 2. from shell command line: beeline -u 'jdbc:hive2://server1.abc.com:10000/default' See if that helps
... View more
09-20-2018
03:52 PM
The error message indicated that the VERSION table is missing, can you confirm the list of all tables you have in your HMS' backend database?
... View more
09-20-2018
03:46 PM
1 Kudo
If you look at the latest Hive code, Table name is 256 characters: https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/mysql/hive-schema-2.3.0.mysql.sql#L586 And column name is 767 characters: https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/mysql/hive-schema-2.3.0.mysql.sql#L55
... View more
09-10-2018
11:08 PM
Hi Romain, I think that's Hue specific setting, not Impala. The goal is to impersonate at Hue level, so instead of using "hue" to connect to Impala, it can impersonate as end user. But at impala side, query still run using "impala" user behind the scene. There are discussions here about impersonation in Impala: https://groups.google.com/a/cloudera.org/forum/#!topic/impala-user/2VBYXNS4ixw Specifically: >>> We do not plan to implement HDFS impersonation and recommend against using it for Hive as well given it's less secure and is incompatible with a fine-grained authorization.
... View more
09-05-2018
11:52 PM
50070 is HDFS's web UI port, it can be configured differently on each cluster. You can check your hdfs-site.xml file and what's the value for dfs.namenode.http-address?
... View more
08-31-2018
08:00 PM
Hue always returns partial result and load more data when you scroll down, is it not working for you?
... View more
08-31-2018
07:59 PM
It is Cloudera Manager's requirement that Oozie is needed before you can install Hue. So you need to have Oozie first.
... View more
08-31-2018
07:40 PM
Not all operations will spill to disk for Impala query, please refer to below doc: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_scalability.html#spill_to_disk Can you share the full PROFILE to understand which part of operation got OOM?
... View more