Re: squirrel sql client to connect to phoenix got TimeOutException

2014-08-13 Thread Russell, Bob
What does your URL look like? It should be in the form: jdbc:phoenix [ : [ : ] [ : ] ] e.g. jdbc:phoenix:zookeeper1:2181:/hbase-unsecure Since squirrel typically doesn't have access to hbase-site.xml, you need to specify port and root node if they are not the defaults. I believe the default

Timestamp

2014-08-08 Thread Russell, Bob
I have an hbase table that was populated some time ago via sqoop from an oracle database. Of particular interest is a column (FROM_DT) which, in oracle database,was defined as a date type. After sqooping to hbase, a scan on the table showed the FROM_DT column as follows: 5229055334*8877933865092

Re: Phoenix and HDP 2.0

2014-07-30 Thread Russell, Bob
aken phoenix 3 is compiled with hbase .94 and phoenix 4 with hbase 98. > but this can be changed. > Do you have any information on a specific error message > > > On Wed, Jul 30, 2014 at 4:34 AM, Russell, Bob > wrote: > >> Any luck with this configuration? Hbase version is 0

Phoenix and HDP 2.0

2014-07-29 Thread Russell, Bob
Any luck with this configuration? Hbase version is 0.96.0.2.0. I've tied Phoenix 3.0 and 4.0 and am having issues with both. Before digging deeper, I figured I'd check to see if there has been success with HDP 2.0 or it's none to not be possible. Thanks, Bob