Re: Importing Postgres-generated CSVs into Phoenix

2016-01-08 Thread James Taylor
Hi Ken, PHOENIX-2434 improved our CSV handling of booleans and will appear in our upcoming 4.7.0 release. It'd be good if you can confirm whether or not this is what you need. We definitely want to support ingest of CSVs from other RDBMSs. There are a couple of other avenues of ingest into

Re: Importing Postgres-generated CSVs into Phoenix

2016-01-08 Thread Ken Hampson
Hi, James: Thanks for the reply. I took a look at the patch attached to PHOENIX-2434, and it does look like it has a good chance to solve the problem, as Postgres exports boolean values as 't' and 'f', which the patch now checks for. Once we're able to get to Phoenix 4.7.0, I'll definitely try it

Re: Importing Postgres-generated CSVs into Phoenix

2016-01-08 Thread James Taylor
Sounds good, Ken. If you could comment on SQOOP-2649 that you'd be interested in using that functionality if it were available, that'd be much appreciated. Thanks, James On Fri, Jan 8, 2016 at 5:04 PM, Ken Hampson wrote: > Hi, James: > > Thanks for the reply. I took a look

Re: Question about support for ARRAY data type with Pig Integration

2016-01-08 Thread Ravi Kiran
Hi Rafa, I will be working on this ticket https://issues.apache.org/jira/browse/PHOENIX-2584. You can add yourself as a watcher to the ticket to see the progress. Regards Ravi On Wed, Dec 23, 2015 at 3:21 AM, rafa wrote: > Hi all !! > > Just a quick question. I see in: >

Re: Importing Postgres-generated CSVs into Phoenix

2016-01-08 Thread Ken Hampson
Sure, no problem. I've added a comment indicating my interest to SQOOP-2649. Thanks, - Ken On Fri, Jan 8, 2016 at 8:33 PM James Taylor wrote: > Sounds good, Ken. If you could comment on SQOOP-2649 that you'd be > interested in using that functionality if it were

Re: strange behavior with DATE columns

2016-01-08 Thread Afshin Moazami
Do you consider adjusting timezones when using JDBC? On Jan 8, 2016, at 3:01 AM, Thomas Decaux > wrote: What about Phoenix shell? I don't see this problem with Datagrip or Phoenix shell. 2016-01-07 20:53 GMT+01:00

Re: Re: error when get data from Phoenix 4.5.2 on CDH 5.5.x by spark 1.5

2016-01-08 Thread Josh Mahonin
[Sent this same message from another account, apologies if anyone gets a double-post] Thanks for the update. I hadn’t even seen the ‘SPARK_DIST_CLASSPATH’ setting until just now, but I suspect for CDH that might be the only way to do it. The reason for the class path errors you see is that the