Re: Phoenix Question

2017-01-24 Thread ankit beohar
HI Sukant, You can use phoenix jdbc driver and retrieve through phoenix sql like we do for mysql or oracle below link may help you:- http://phoenix.apache.org/installation.html Best Regards, ANKIT BEOHAR On Wed, Jan 25, 2017 at 10:23 AM, Sukant Jain wrote: > Hi Team, > > First i w

Re: Phoenix and HBase data type serialization issue

2016-08-24 Thread ankit beohar
HI Gabriel, Thanks for your quick reply, but in my case I am using Talend ETL tool to ingest the data into HBase, so I can not use PDataType subclasses and in Talend Phoenix connector is not avaialble. Is there any other way? Best Regards, ANKIT BEOHAR On Wed, Aug 24, 2016 at 1:31 PM, Gabriel

Phoenix and HBase data type serialization issue

2016-08-24 Thread ankit beohar
date,"0"."SALARY" bigint); No rows affected (0.347 seconds) 0: jdbc:phoenix:localhost:2181> select "0"."dates" from "CEHCK_DT"; +---+ | dates | +-------+ | 177670840-04-13 05:44:22.317 | | 177670840-04-13 05:44:22.317 | | 177670840-04-13 05:44:22.317 | +---+ Best Regards, ANKIT BEOHAR

Re: Phoenix Ifnull

2016-08-12 Thread ankit beohar
Hi Lukáš/James, I have one table in which only one rowkey is available and for my null check case I am firing below queries and in that null check is not working:- [image: Inline image 1] Please see and let me know if I am doing right thing or missed something. Best Regards, ANKIT BEOHAR On

Apache Phoenix in Unix Shell

2016-08-11 Thread ankit beohar
Hi All, I want to write unix shell script for phoenix query like we are doing in MySQL. Can anybody share the way. Best Regards, ANKIT BEOHAR

Phoenix Ifnull

2016-08-11 Thread ankit beohar
heckDump"; Best Regards, ANKIT BEOHAR

HBase region server down

2016-07-29 Thread ankit beohar
Hi All, I set phoenix timeout is 3hr, rpc 3hr and query alive is also 3hr but for bigger query whenever phoenix calltimeout occurs my hbase region server also goes down, I do not know what is happening. Please help me out on this. Best Regards, ANKIT BEOHAR

HBase prefix scan.

2016-07-19 Thread ankit beohar
Hi All, How can I achieve HBase Prefix Filter in Phoenix query. My rowkey is 9898989898_@#$_ABC I want all records of 9898989898_@#$ which is achieve in Hbase through prefix filter I need same in Phoenix query. Best Regards, ANKIT BEOHAR