RE: Backup and Recovery for disaster recovery

Am not very sure if Phoenix directly has any replication support now. But in your case as you are bulk loading the tables you are not able to replicate but that problems is addressed in HBase As part of https://issues.apache.org/jira/browse/HBASE-13153 Where bulk loaded files can get replicated

Re: Backup and Recovery for disaster recovery

Did you check my response to your previous mail? On Wednesday, December 23, 2015, Krish Rajan wrote: > Hi, > > We’re using HBase under phoenix. Need to setup DR site and ongoing > replication. > Phoenix tables are salted tables. In this scenario what is the best method > to copy data to remote c

Backup and Recovery for disaster recovery

Hi, We’re using HBase under phoenix. Need to setup DR site and ongoing replication. Phoenix tables are salted tables. In this scenario what is the best method to copy data to remote cluster? People give different opinions. Replication will not work for us as we’re using bulk loading. Can you adv

Two different UDFs called on same column return values from first UDF only

I have two user defined functions which extends ScalarFunction taking same column as parameter and outputs different results. If i execute the functions seperately in two different select caluse i am getting the expected output. If i use the two functions in a same select clause the first function

Re: Backup and Recovery for disaster recovery

You have two options: - save the hfiles created during bulk load & import on DR cluster - after bulk-loading, export table on the live cluster & import to DR cluster On Monday, December 21, 2015, Krishnasamy Rajan wrote: > Hi, > > We’re using HBase under phoenix. Need to setup DR site and ongoin

RE: using between for dates

Ns > between current_date() and (current_date()-2000) > Shouldn’t this be in the format “between and ”? Looks like you have things reversed. Michael McAllister Staff Data Warehouse Engineer | Decision Systems mmcallis...@homeaway.com | C: 512.423.7447 | skype:

Question about support for ARRAY data type with Pig Integration

Hi all !! Just a quick question. I see in: https://phoenix.apache.org/pig_integration.html that the array data type will be supported in the future. Anybody knows if that work has been started and if there is a future release in which this feature will be included? Thank you very much in advan

REG: using between for dates

Hi Team, I want to fetch records with date column between current date and a past date. Currently when i use between in phoenix it is not working. Can any one help? Query: SELECT id,to_date(SUBSTR(ID2, (LENGTH(ID2)-7), 8),'MMdd','GMT') FROM table1 h WHERE to_date(SUBSTR(ID2, (LENGTH(ID2)-7

Re: REG: Accessing Phoenix in a kerberised Cluster

Thank you James and Anil. On Wed, Dec 23, 2015 at 12:51 PM, anil gupta wrote: > Hi James, > That blogpost( > http://bigdatanoob.blogspot.com/2013/09/connect-phoenix-to-secure-hbase-cluster.html) > did not cover how to natively connect to a secure cluster for Phoenix3.0+ > releases. I have update