Please follow below instructions: Instructions to add Tez and Hive on Tez: 1. Add Tez service on the cluster. 2. Run sudo -u hdfs hdfs dfs -mkdir /user/tez
sudo -u hdfs hdfs dfs -put /opt/cloudera/parcels/CDH/lib/tez/tez.tar.gz /user/tez 3. Add Hive on Tez service.
... View more
Are you not able to connect to hiveserver2 from beelne ? You are not able to view tables in the databases? Please provide a screenshot and also the beeline trace and url.
... View more
Please provide driver DEBUG To enable logging in the driver please modify the odbc.ini file and under the [Driver] section set LogLevel to 6 and LogPath to point to a writeable directory where you would like to driver to create the log files in. For example: [Driver] LogLevel=6 LogPath=/tmp
... View more
By default hive displays in UTC. If you want to use specific timestamp,you can run below command SELECT from_utc_timestamp(cast(from_unixtime(cast(1623943533 AS bigint)) as TIMESTAMP),"Asia/Kolkata") ;
... View more
I believe this issue is the result of upgrade. Did you upgrade from 3.0.1 to 3.1.0 ? In which version you were using Embedded mode ? Can you recreate the metadata if this is not production and check ?
... View more
You have to whitelist the parameter to be configured in beeline . Please follow https://docs.cloudera.com/cdp/latest/data-migration/topics/ug_hive_property_overview.html
... View more
