Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

New Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

Expert Contributor

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>

1 REPLY 1

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

Expert Contributor

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>