I got following error when I tried that: java -cp "/etc/hbase/conf:/usr/hdp/2.2.0.0-2041/phoenix/bin/../phoenix-4.2.0.2.2.0.0-2041-client.jar" -Dlog4j.configuration=file:/usr/hdp/2.2.0.0-2041/phoenix/bin/log4j.properties sqlline.SqlLine -d org.apache.phoenix.jdbc.PhoenixDriver -u jdbc:phoenix:localhost:2181:/hbase-unsecure;tenantid=abc -n none -p none --color=true --fastConnect=false --verbose=true --isolation=TRANSACTION_READ_COMMITTED
15/03/12 23:48:02 WARN impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties Error: (state=,code=0) sqlline version 1.1.2 Vamsi Attluri. On Thu, Mar 12, 2015 at 4:00 PM, Nick Dimiduk <ndimi...@gmail.com> wrote: > It looks like tenantId is passed on as a jdbc property. So I think > localhost:2181:/hbase becomes localhost:2181:/hbase;tenantId=abc. At least > that's what's happening in JDBCUtilTest. > > On Thu, Mar 12, 2015 at 3:24 PM, Vamsi Krishna <vamsi.attl...@gmail.com> > wrote: > >> Hi, >> >> Can someone help me understand how to establish a tenant-specific >> connection using Sqlline? >> >> I see the following documented on Phoenix website, but i'm not sure how >> to do that for Sqlline connection: >> >> http://phoenix.apache.org/multi-tenancy.html >> >> For example, a tenant-specific connection is established like this: >> >> Properties props = new Properties(); >> props.setProperty("TenantId", "Acme"); >> Connection conn = DriverManager.getConnection("localhost", props); >> >> Thanks, >> Vamsi Attluri. >> > >
