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

2016-11-26 Thread Josh Elser
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 Sat

Re: phoenix-Hbase-client jar web application issue

2016-11-26 Thread Josh Elser
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. org.apache.pho

Re: Unable to find cached index metadata

2016-11-26 Thread James Taylor
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" wrote: > > I believe that issue has

Re: Unable to find cached index metadata

2016-11-26 Thread Neelesh
Thanks James! Is there a jira ref for the fix? On Nov 26, 2016 11:50 AM, "James Taylor" wrote: > I believe that issue has been fixed. The 4.4 release is 1 1/2 years old > and we've had five releases since that have fixed hundreds of bugs. Please > encourage your vendor to provide a more recent r

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

2016-11-26 Thread James Taylor
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 explicitly make the commi

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

2016-11-26 Thread Matt L
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 upsert (either by turning

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

2016-11-26 Thread James Taylor
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: > > %phoenix > create tabl

Re: Unable to find cached index metadata

2016-11-26 Thread James Taylor
I believe that issue has been fixed. The 4.4 release is 1 1/2 years old and we've had five releases since that have fixed hundreds of bugs. Please encourage your vendor to provide a more recent release. Thanks, James On Sat, Nov 26, 2016 at 10:23 AM Neelesh wrote: > Hi All, > we are using pho

Unable to find cached index metadata

2016-11-26 Thread Neelesh
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 [RW.default.writeRpcServer.handler=40,queu