Spark can't connect to secure phoenix

Hi All, I am running a spark program on secured cluster which creates SqlContext for creating dataframe over phoenix table. When I run my program in local mode with --master option set to local[2] my program works completely fine, however when I try to run same program with master option set t

Decode rowkey

Hi, Does Phoenix have API for converting a rowkey (made up of multiple columns) and in ImmutableBytesRow format to split into primary key columns? I am performing a scan directly from HBase and would like to convert the rowkey into column values. We used Phoenix standard JDBC API while writing to

Re: Decode rowkey

This would be really useful. The use case I have that is similar is to map Phoenix data to Hive (but the subset of Hive that Impala understands). I imagine it could work by reading the System.catalog table, or connection metadata, and generating Hive create table statements. There would need to

Re: Decode rowkey

See http://search-hadoop.com/m/9UY0h2ZCvra1NlgtC1&subj=Re+Extracting+column+values+from+Phoenix+composite+primary+key On Fri, Sep 16, 2016 at 10:46 AM, Jonathan Leech wrote: > This would be really useful. The use case I have that is similar is to map > Phoenix data to Hive (but the subset of Hiv

RE: Exception connection to a server with pheonix 4.7 installed

Hi, Josh: Thanks for the suggestion. Adding hbase-site.xml in spark conf directory solves the problem Xindian -Original Message- From: Josh Elser [mailto:josh.el...@gmail.com] Sent: Thursday, September 15, 2016 5:43 PM To: user@phoenix.apache.org Subject: Re: Exception connection to a

LOCAL vs TRANSACTIONAL indexes

All, I would like some guidance on LOCAL vs TRANSACTIONAL indexes and I cannot quite get the details I need from the Phoenix site: https://phoenix.apache.org/secondary_indexing.htm Transactional Tables transactional tables with secondary indexes potentially lowers your availability of being abl

Re: Joins dont work

here (root-queryserver.log): > 2016-09-16 23:40:18,378 INFO > org.apache.hadoop.hbase.client.RpcRetryingCaller: > 2016-09-16 23:40:18,420 WARN > org.apache.hadoop.hbase.ipc.CoprocessorRpcChannel: Call failed on > IOException > org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after

Re: Decode rowkey

HI, Please use the attached utils. let me know if you see any issue. thanks. Regards, Anil On 16 September 2016 at 22:45, Krishna wrote: > Hi, > > Does Phoenix have API for converting a rowkey (made up of multiple > columns) and in ImmutableBytesRow format to split into primary key columns?