Re: Phoenix Pig integration

ion. > > PS: At my workplace, we have had many challenges in integration of HBase > and Avro with Oozie4.2. > > Thanks, > Anil Gupta > > On Fri, Aug 14, 2015 at 7:24 AM, Pariksheet Barapatre < > pbarapa...@gmail.com> wrote: > >> Hi Ravi/All, >> >> When I

Re: Phoenix Pig integration

help in advance. Regards Pari On 12 August 2015 at 17:59, Pariksheet Barapatre wrote: > Many Thanks Ravi. > > Your solution worked. Let me get a JIRA. > > Thanks > Pari > > On 10 August 2015 at 20:08, Ravi Kiran wrote: > >> Hi Pari, >>I wrote a qui

Re: Phoenix Pig integration

n anyone please help ? Many Thanks Pari On 10 August 2015 at 13:12, Pariksheet Barapatre wrote: > Hi Russell, > > below error I am getting in pig.log > Failed to parse: null > at > org.apache.pig.parser.QueryParserDriver.parse(QueryParserDriver.java:198) >

Re: Phoenix Pig integration

;/home/yumecorp/phoenix-4.2.0-bin/phoenix-4.2.0-client.jar'; Thanks Pari On 10 August 2015 at 12:50, Russell Jurney wrote: > There shouldn't be a limitation, no. I've stored to/read from Phoenix > tables from Pig on CDH 5. > > Can you paste the error? > > &g

Phoenix Pig integration

Hi All, I am trying to run Pig script on Phoenix table. I am using same example given in documentation. CREATE TABLE HIRES( CLIENTID INTEGER NOT NULL, EMPID INTEGER NOT NULL, NAME VARCHAR CONSTRAINT pk PRIMARY KEY(CLIENTID,EMPID)); raw = LOAD 'hbase://table/HIRES USING org.apache.phoenix.pig.P

Data Model Suggestion

Hello All, This is more like a HBase question but as I am planning to use Phoenix as a access layer, I hope phoenix user will help me. I would like to create time series data to get on-the-fly analytics. This use case is for adTech. Report - what is houly,daily,weekly impression counts at count

Phoenix 4.2 - TableNotFound error

Hi, Getting weird error - We are trying to run below query, through JDBC SELECT * FROM ABC.TABLE_2 ; ERROR - org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=ABC.TABLE_2 at org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableR

Re: Phoenix monitoring

Thanks Ted. Cheers Pari On 12 February 2015 at 11:38, Ted Yu wrote: > w.r.t. release of 4.3, see this thread: > http://search-hadoop.com/m/lz2la1mCuXS > > Cheers > > On Wed, Feb 11, 2015 at 9:46 PM, Pariksheet Barapatre < > pbarapa...@gmail.com> > wrote: >

Re: Phoenix monitoring

tor for a Phenox application that can > report > > into OpenTSDB; I think JDBC metrics are available via JMX. That would be > a > > great addition for that project! > > > > I've also seen a product demo from HP that does a lot of this for other > > tools

Phoenix monitoring

Hello All, Can you suggest good monitoring tool for phoenix. Our QA hbase cluster is crashing randomly. We wanted to know stats like which query causing the issue and how many queries running on that particular time window, resource consumption of query etc. Cheers Pari

Re: Pheonix equivalent HFile

ix-core/src/main/java/org/apache/phoenix/mapreduce/CsvBulkLoadTool.java > 2. > https://github.com/apache/phoenix/blob/master/phoenix-core/src/main/java/org/apache/phoenix/mapreduce/CsvToKeyValueMapper.java > > On Sun, Jan 11, 2015 at 6:34 PM, Pariksheet Barapatre > wrote: > > H

Re: Pheonix equivalent HFile

Many Thanks for quick pointer. Let me go through the link and get back. Cheers Pari On 11 January 2015 at 23:10, Ted Yu wrote: > Have you looked at https://issues.apache.org/jira/browse/PHOENIX-1454 ? > > Cheers > > On Sun, Jan 11, 2015 at 9:34 AM, Pariksheet Barapatre < >

Pheonix equivalent HFile

Hello All, New year greetings..!!! My question as follow - How to create Phoenix Salted table equivalent HFile using MapReduce. As per my understanding we can create HFile by specifying HFileOutputFormat.configureIncrementalLoad(job, hTable); What would be the way to create salt and generat

Re: Pheonix Questions

problem. > > Similarly for (3). > > > > 2) update_statistics is available in 4.2 onwards. > > > > Regards > > Ram > > > > -Original Message- > > From: Pariksheet Barapatre [mailto:pbarapa...@gmail.com] > > Sent: Thursday, November 1

Pheonix Questions

Hello Guys, Hope everybody keeping good. I have few questions - Tested ON - Phoenix4.1 , HBase0.98.1 , 7 RS heap Size - 8 GB 1) PIG gives error whenever I am trying to LOAD data from Salted Phoenix table A = LOAD 'hbase://table/RAW_LOG' USING org.apache.phoenix.pig.PhoenixHBaseLoader('pari');

How to use Hints in Phoenix queries

Hi All, Want to use NO_CACHE Hint , how to use it . Any example or documentation ? http://phoenix.apache.org/language/index.html#cache_hint does not help really. UPSERT INTO TABLE1 SELECT * from TABLE2. How to use cache hint here.. Cheers, Pari

Re: Pheonix Questions

Resending in case not reached to dev list On 13 November 2014 16:12, Pariksheet Barapatre wrote: > Hello Guys, > > Hope everybody keeping good. > > I have few questions - > > Tested ON - Phoenix4.1 , HBase0.98.1 , 7 RS heap Size - 8 GB > > 1) PIG gives error whenev