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

[#1]

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?

[#2 · Accepted solution]

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>