Member since
07-17-2019
738
Posts
433
Kudos Received
111
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2623 | 08-06-2019 07:09 PM | |
2856 | 07-19-2019 01:57 PM | |
4078 | 02-25-2019 04:47 PM | |
4038 | 10-11-2018 02:47 PM | |
1345 | 09-26-2018 02:49 PM |
02-01-2016
05:46 PM
The difference is that Michael showed a SocketTimeoutException in the timeout. That's most likely the HBase RPC framework limiting the lifetime of the socket, not the Phoenix application-level timeout you listed (which is still good to remember!)
... View more
01-30-2016
12:15 AM
1 Kudo
The "thick" Phoenix driver does all the RPC with HBase directly. The "thin" Phoenix driver only communicates with the Phoenix QueryServer over HTTP (the QueryServer communicates to HBase on its behalf). You shouldn't see any differences between the two approaches.
... View more
01-29-2016
11:39 PM
1 Kudo
Can you try enabling log4j DEBUG by editing /usr/hdp/current/phoenix-client/bin/log4j.properties? Set psql.root.logger=DEBUG,console and log4j.threshold=DEBUG, I believe they would be at INFO or WARN by default.
... View more
01-29-2016
11:36 PM
2 Kudos
Not relevant to your question, but that's the "normal" (thick) Phoenix driver. The "thin" Phoenix driver (with Phoenix QueryServer) is accessed using sqlline-thin.py.
... View more
01-29-2016
09:33 PM
2 Kudos
In hbase-site.xml, set 'hbase.regionserver.thrift.port' for Thrift 1 or 'hbase.thrift.info.port' for Thrift 2
... View more
01-26-2016
06:53 PM
8 Kudos
ZooKeeper Session expirations (e.g. "org.apache.zookeeper.KeeperException$SessionExpiredException:KeeperErrorCode=Session expired for/hbase-unsecure/rs/node03.test.com,16000,1453750627948") are a common issue that HBase can run into, although there are often a number of reasons which could cause this error. Background: ZooKeeper clients need to maintain a "heartbeat" (a regular RPC to a ZooKeeper server) to maintain their session (credits to Apache ZooKeeper: http://zookeeper.apache.org/doc/r3.4.6/images/state_dia.jpg) Without an active Session, clients cannot interact with ZooKeeper. In the HBase context, this means that HBase will continually try to connect to the server to put whatever state is necessary. Some common reasons that this heartbeat fails: JVM garbage collections. Pauses in the HBase JVM can cause the heartbeat to not occur regularly. Look at JVM GC logs to identify this. HBase will also include messages in the service logs when it notices this happening. Host-level pauses. The node moving parts of the JVM out of memory and into swap (backed by disk) can cause pauses the entire JVM without any garbage collections. HBase will often notice this too, but report a pause without any garbage collections happening. Excess clients to ZooKeeper -- exceeding `maxClientCnxns` in zoo.cfg. See the ZooKeeper docs for a full description of this property, but the summary is that this property is used to rate-limit connections from one host. This is meant to prevent a denial of service attack, however, excessive load from a combination of HBase, MapReduce and other services can trigger this protection. In this case, clients are regularly trying to heartbeat to ZooKeeper, but the ZooKeeper server is actively *denying* the connection because it would exceed `maxClientCnxns` number of connections from the same host. You can use `netstat` to verify this is happening and/or check the ZooKeeper server log. While removing the contents of HBase's root znode can be a temporary fix (especially with older versions which heavily rely on ZooKeeper for region assignments), this is often indicative of a much larger problem which will continue to occur in the future.
... View more
01-26-2016
03:15 AM
1 Kudo
I am not sure, but I can see if we have any public roadmap posted for you.
... View more
01-26-2016
12:41 AM
2 Kudos
You cannot currently perform multiple upserts within a single HTTP call to the Phoenix QueryServer. Support for commit/rollback was recently added to Calcite (the technology behind the Phoenix QueryServer) in https://issues.apache.org/jira/browse/CALCITE-767 which is relevant for what you're trying to do. However, this was not yet released in a version of HDP. The ability to use commit and rollback lets you batch multiple calls inside of the PQS instance before committing them to HBase.
... View more