Re: ClassNotFoundException for UDF class

2015-07-27 Thread Anchal Agrawal
Hi James and Rajeshbabu, Thank you for your replies. My hbase-site confs are being picked up, I have confirmed it by deliberately misconfiguring one of the properties. Rajeshbabu, instead of HDFS, I have a custom NFS setup for which I have specified the fs.nfs.impl property in hbase-site. I've pu

Re: Getting errors in Phoenix queries with JOIN clause[Phoenix version 3.2.2]

2015-07-27 Thread rajeshb...@apache.org
Hi Samantha, You are facing this issue https://issues.apache.org/jira/browse/PHOENIX-2007 got fixed in latest code. You get the error when there is no data in the table so you can load some data and try. Thanks, Rajeshbabu. On Mon, Jul 27, 2015 at 5:50 PM, Sumanta Gh wrote: > Hello, > > I'm g

Getting errors in Phoenix queries with JOIN clause[Phoenix version 3.2.2]

2015-07-27 Thread Sumanta Gh
Hello, I'm getting an error (Error: Encountered exception in sub plan [0] execution. (state=,code=0)) with Apache Phoenix version 3.2.2 while I'm trying to execute a query with INNER JOIN or LEFT OUTER JOIN or with sub-query.I'm using sqlline.py client from hadoop1/bin directory found under Pho

Re: ClassNotFoundException for UDF class

2015-07-27 Thread rajeshb...@apache.org
Hi Anchal Agrawal, Have you place the jar in HDFS? and the path_to_jar in the create function is the URI for the jar in hdfs? Thanks, Rajeshbabu. On Sat, Jul 25, 2015 at 5:58 AM, James Taylor wrote: > Are you sure your hbase-site.xml is being picked up on the client-side? > I've seen this hap

Re: Phoenix ODBC Connection

2015-07-27 Thread Lukáš Lalinský
Even more adventurous option would be to write a native .NET client for the query server. :) My Python implementation could be used as a reference for that: https://bitbucket.org/lalinsky/python-phoenixdb/src/master/phoenixdb/?at=master There are some problems with the current query server in Ph