Salted Table meta information

2015-02-27 Thread Dhaval Rami
Hi All, I am using Salted Tables, I am trying to understand what will happen if one of my salt bucket splits. ( the region splits). How will scan be performed on two newly formed regions? does phoenix maintain a meta info for regions to salt key, or it just will send scans to all

Re: SQL to export query result in a CSV file ?

2015-02-25 Thread Dhaval Rami
, $ZKEEPER - Zoo Keeper quorum , $TMP_FILE - output csv path Cheers Pari On 25 February 2015 at 21:25, Dhaval Rami dhavalr...@gmail.com wrote: Is there a way I can do this from a shell script ? ( I want to automate a report export ) Thanks, Dhaval On Tue, Feb 24, 2015 at 10:16 PM, Dhaval

SQL to export query result in a CSV file ?

2015-02-24 Thread Dhaval Rami
Is there any SQL statement which can enable me to save query results as CSV file on a local file system / hdfs ? Thanks, Dhaval

Phoenix with Hbase Transparent Encryption of Data At Rest

2015-02-24 Thread Dhaval Rami
An FYI, I tried using phoenix in hBase with Transparent Encryption of Data At Rest enabled ( AES encryption) Works fine for a table with primary key column. But it doesn't work if I create Secondary index on that tables.I tried to dig deep into the problem and found WAL file encryption throws

Re: SQL to export query result in a CSV file ?

2015-02-24 Thread Dhaval Rami
data.csv 3. select * from system.catalog limit 10; 4. !record 5. !quit You should see data.csv file with 10 records from system.catalog table saved in the folder from which you executed sqlline.py. Thanks, Vamsi Attluri. On Tue, Feb 24, 2015 at 1:32 PM, Dhaval Rami dhavalr...@gmail.com wrote

Local index working

2015-01-30 Thread Dhaval Rami
Hi All, Can any one point me to a link that explains working of local index. What I am trying to understand is, how local index is managed at HBase level. Thanks, Dhaval