This works fine for me: $ ./bin/sqlline.py localhost:2181:/hbase;tenantId=foo
At least, it launches without complaint. I don't have any tables with tenants enabled. On Thu, Mar 12, 2015 at 4:48 PM, Vamsi Krishna <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> >> 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. >>> >> >> >
