TinyInt, SmallInt not supported in Pig Phoenix loader

2016-02-13 Thread anil gupta
Hi, We are using Pig-Phoenix loader to load data into a table. Initially, we created some columns as TinyInt and SmallInt in our Phoenix table. But, Pig does not have TinyInt and SmallInt datatypes, so we were forced to convert all TinyInt and SmallInt columns into INTEGER. Is there a way/trick

Re: TinyInt, SmallInt not supported in Pig Phoenix loader

2016-02-13 Thread Ravi Kiran
Hi Anil, We do a mapping of PTintInt and PSmallInt to Pig DataType.INTEGER . https://github.com/apache/phoenix/blob/master/phoenix-pig/src/main/java/org/apache/phoenix/pig/util/TypeUtil.java#L94 . Can you please share the error you are seeing. HTH Ravi. On Sat, Feb 13, 2016 at 3:16 AM,

Re: Phoenix and HBase Snapshots

2016-02-13 Thread Sandeep Nemuri
We have tried taking/restoring snapshots of Phoenix tables. How does it work ? As Gaurav mentioned , We should take snapshot or restore snapshot from hbase of the phoenix tables. Thanks Sandeep ᐧ On Sat, Feb 13, 2016 at 8:20 AM, James Taylor wrote: > Specifically

Re: TinyInt, SmallInt not supported in Pig Phoenix loader

2016-02-13 Thread James Taylor
I think the question Anil is asking is "Does Pig have support for TinyInt (byte) and SmallInt (short)?" I don't know the answer. On Sat, Feb 13, 2016 at 9:46 AM, Ravi Kiran wrote: > Hi Anil, > >We do a mapping of PTintInt and PSmallInt to Pig DataType.INTEGER . >

Re: TinyInt, SmallInt not supported in Pig Phoenix loader

2016-02-13 Thread anil gupta
I think, Ravi answered my question. One of my team mate was working on Pig-Phoenix loader so i'll share this with him. We will update once we try this out. Thanks Guys. On Sat, Feb 13, 2016 at 10:01 AM, James Taylor wrote: > I think the question Anil is asking is "Does