How can I pass hbase settings to the phoenix shell as command line arguments?

jdupont — Thu, 07 Feb 2019 01:47:42 GMT

When I execute quires that return large results in the phoenix shell (sqlline.py), I get the following error:

org.apache.hadoop.hbase.UnknownScannerException: org.apache.hadoop.hbase.UnknownScannerException: Name: 33164, already closed?

Which will probably be resolved by the solution posted here. However, I do not have permission to edit the hbase-site.xml so I need to pass the settings as command line arguments when starting the phoenix shell. Previously we have used the `--conf hbase.rpc.timeout=xxx` syntax on other jobs, but I can't find a way to pass that into the phoenix shell.

So my question is: Can I pass those settings as arguments when starting the sqlline.py or can I set them while already inside?

Re: How can I pass hbase settings to the phoenix shell as command line arguments?

schhabra1 — Thu, 07 Feb 2019 19:03:22 GMT

You can copy hbase-site.xml in your directory and make changes in that hbase-site.xml.

Then export below property and launch sqlline.

export HBASE_CONF_DIR=<new directory where you have copied hbase-site.xml>

question Re: How can I pass hbase settings to the phoenix shell as command line arguments? in Support Questions

How can I pass hbase settings to the phoenix shell as command line arguments?

Re: How can I pass hbase settings to the phoenix shell as command line arguments?