Member since
07-28-2016
7
Posts
1
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
7095 | 08-31-2016 08:06 PM | |
4334 | 07-28-2016 02:11 PM |
10-08-2016
03:03 PM
MySQL considres differently based on hostname. Try this: mysql> set PASSWORD FOR 'hive'@'%' = PASSWORD('cloudera');
... View more
09-13-2016
11:33 AM
Hi, First connect to MySQL session with root: $mysql -u root -pcloudera mysql> set PASSWORD FOR 'hive'@'localhost' = PASSWORD('cloudera'); Good luck.
... View more
08-31-2016
08:06 PM
1 Kudo
The issue is because hive authentication to metastore is failing. Not sure how hive user password is reset. I have reset hive user password to cloudera & restarted the VM. Able to launch shell & execute properly now.
... View more
08-31-2016
06:18 PM
Hive gives problems on my CDH5.7 Quickstart VM recently. Hive command takes forever to launch shell. It took about 30 min to start the shell session. Even after shell is launched, it doesn't execute commands. $ hive 2016-08-31 15:48:27,827 WARN [main] mapreduce.TableMapReduceUtil: The hbase-prefix-tree module jar containing PrefixTreeCodec is not present. Continuing without it. Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j.properties ................ HERE IT TAKES VERY VERY LONG TIME TO COME BACK. WARNING: Hive CLI is deprecated and migration to Beeline is recommended. hive> show databases; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out) hive>show tables; ................ AFTER VERY VERY LONG TIME, GIVES BELOW ERROR. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out hive> ----- No entries in log files (/var/log/hive/) with "DDLTask" error string, but found with "TTransportException". Some Hive log entries (not result of these execution though): /var/log/hive/hive-server2.log 2016-08-31 15:55:49,121 WARN [main]: hive.metastore (HiveMetaStoreClient.java:open(445)) - set_ugi() not successful, Likely cause: new client talking to old server. Continuing without it. org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) I have run few Hive examples previously & saw the Hive repository metadata (table columns) in mySQL database.. Anybody had faced the similar issues? Thanks in advance.
... View more
Labels:
07-28-2016
01:39 PM
Hi cjervis, Thanks for your response. I added a VM in VirtualBox & mapped the extracted vmdk file. I wil try the Import Appliance option & update my results. Regards, Kiran
... View more
07-28-2016
12:56 PM
CDH 5.7 doesn't launch on my VirtualBox 5.1. It thinks for a very long time on the black screen with white band & text "Centos 6.7", finally it givesbunch of error messages with different ids (I think process id's): init: prefdm main process (xxxx) terminated with status 1 init: prefdm main process ended, respawing (xxxx is numeric, like 3528, 3538,3558,3568,3588, 3598... They follow a pattern though.. ) Then the last entry is: init: prefdm respawning too fast, stopped My investigation: 1. The hash code of the downloaded file is correct. 2. My virtualBox is working fine, I am able to launch a new Centos7 VM using CentOS iso. So I don't think it is problem with VirtualBox. I would appreciate if anybody had faced the issue & got a fix for this... Regards, Kiran
... View more
Labels: