Re: Upsert works using /sqlline-thin.py and /sqlline.py but not in Zeppelin or other remote jdbc clients

Or make sure that Zeppelin is adding hbase-site.xml to the classpath. You can easily test this by making a copy of your phoenix-client.jar and manually adding in a copy of hbase-site.xml to the jar. James Taylor wrote: https://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html On

Re: phoenix-Hbase-client jar web application issue

Great, glad you got it working. pradeep arumalla wrote: finally success, just exclude the offending classes, mine were, so yours would be too, if you are trying to connect jdbc driver from a web server.Please exclude the classes below from the pom file in phoenix-client folder.

Re: Unable to find cached index metadata

Not sure of the JIRA, but it sounds familiar. Try searching for it here: https://issues.apache.org/jira/browse/PHOENIX On Sat, Nov 26, 2016 at 1:22 PM Neelesh wrote: > Thanks James! Is there a jira ref for the fix? > > On Nov 26, 2016 11:50 AM, "James Taylor"

Re: Upsert works using /sqlline-thin.py and /sqlline.py but not in Zeppelin or other remote jdbc clients

https://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html On Sat, Nov 26, 2016 at 12:39 PM Matt L wrote: > I had set auto.commit = true in my hbase-site.xml bit don't think the JDBC > connections are picking that up. > > How do I turn it on in the connection or

Re: Upsert works using /sqlline-thin.py and /sqlline.py but not in Zeppelin or other remote jdbc clients

I had set auto.commit = true in my hbase-site.xml bit don't think the JDBC connections are picking that up. How do I turn it on in the connection or explicitly make the commit? On Sat, Nov 26, 2016 at 3:13 PM, James Taylor wrote: > Are you committing the data after the

Re: Upsert works using /sqlline-thin.py and /sqlline.py but not in Zeppelin or other remote jdbc clients

Are you committing the data after the upsert (either by turning on auto commit on the connection or doing an explicit commit)? On Fri, Nov 25, 2016 at 12:20 PM Matt L wrote: > Hello All! > > Through Zeppelin I am trying to insert data into a table created by > Phoenix: > >

Unable to find cached index metadata

Hi All, we are using phoenix 4.4 with HBase 1.1.2 (HortonWorks distribution). We're struggling with the following error on pretty much all our region servers. The indexes are global, the data table has more than a 100B rows 2016-11-26 12:15:41,250 INFO