i got the same problem. When I reinstalled hive, everything worked. ... View more

@arunpoy  If we are using the CDH/CDP both timeout parameters(hbase.rpc.timeout & hbase.client.scanner.timeout.period) need to be added in both server-side and client-side in the below paths from the HBase configuration. HBase Service Advanced Configuration Snippet (Safety Valve) for hbase-site.xml HBase Client Advanced Configuration Snippet (Safety Valve) for hbase-site.xml   Bothe the time-out parameters need to be added on the server and client-side and RPC(hbase.rpc.timeout) time-out needs to be set a bit higher than the client scanner time-out (hbase.client.scanner.timeout.period). ... View more

This solution is works for me on HDP 3.1.4 Ambari 2.7   Thanks for sharing. ... View more

Hi  sandyy006,   I am creating connections in this way:   Connection connection = DriverManager.getConnection("jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF"   but how the value for phoenix.query.timeoutMs is read by the driver?   Thank you very much in advanced!   ... View more

Hi,  You must deploy the jce policy on every cluster nodes if you are using built-in openjdk. Please follow the steps. [root@hostname]# locate local_policy.jar [root@hostname]# wget --no-check-certificate --no-cookies --header "Cookie: oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jce/8/jce_policy-8.zip" [root@hostname]# unzip -o -j -q jce_policy-8.zip -d /usr/jdk64/jdk1.8.0_112/jre/lib/security/ [root@hostname]# ambari-server rstart   Now test the connection. Hopes it will resolves the issue.   ... View more

@TonyQiu, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

The Phoenix-Hive storage handler as of v4.14.0 (CDH 5.12) seems buggy.  I was able to get the Hive external wrapper table working for simple queries, after tweaking column mapping around upper/lower case gotchas.  However, it fails to work when I tried the "INSERT OVERWRITE DIRECTORY ... SELECT ..." command to export to file: org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=<table name>   This is a known problem that no one is apparently looking at: https://issues.apache.org/jira/browse/PHOENIX-4804   ... View more

Hi, Can you please have look at this: HBase 2nd Incremental Backup/Restore not Working  ... View more

@Moka Have you resolved your issue? What steps did you followed?  ... View more

you saved my day! ... View more