Re: using MapReduce java.sql.SQLException: No suitable driver found for jdbc:phoenix occured.

2016-09-14 Thread Josh Elser
phoenix-4.8.0-HBase-1.1-client.jar is the jar which should be used. The phoenix-4.8.0-HBase-1.1-hive.jar is to be used with the Hive integration. dalin.qin wrote: [root@namenode phoenix]# findjar . org.apache.phoenix.jdbc.PhoenixDriver Starting search for JAR files from directory . Looking for

Re: How to manually generate a salted row key?

2016-09-14 Thread Marica Tan
Hi Josh, It turns out the salt bucket in the create table script is different than what we're using in the generation of row key :D Anyway thanks for the help :) Marica On Wed, Sep 14, 2016 at 3:33 PM, Marica Tan wrote: > Hi Josh, > > It works without salting. Tried

Re: How to manually generate a salted row key?

2016-09-14 Thread Marica Tan
Hi Josh, It works without salting. Tried the getSaltedKey but still the same problem. The generated row key when doing an upsert via phoenix sqlline, is different and I can query the one created via phoenix. via phoenix: \x09O1IC\x00CUSTOMER\x0076s7DeAqt82_1LFY7brsTA via hbase api: