About rathnamohan_b

dzaratsian · ‎01-02-2017

Hi @rathna mohan, for Phoenix 4.0 and above, you'll want to use this syntax: HADOOP_CLASSPATH=/path/to/hbase-protocol.jar:/path/to/hbase/conf hadoop jar /usr/hdp/2.4.2.0-258/phoenix/phoenix-4.4.0.2.4.2.0-258-client.jar org.apache.phoenix.mapreduce.CsvBulkLoadTool --view UDM_TRANS --input /home/hadoop1/sample.csv Make sure to change the path to hbase-protocol.jar and the path to HBase conf to match your environment. Give this a try and let me know if it helps. Additional Link for Phoenix Bulk Loading: https://phoenix.apache.org/bulk_dataload.html

aervits · ‎12-29-2016

@rathna mohan I have not tested this but it may be possible to use HBase API to achieve what you're asking, https://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/ColumnPaginationFilter.html. I am just guessing and I don't think it will be a trivial effort as you're going to have to access Phoenix from HBase API. Again, I hesitate to suggest this route as effort to develop this functionality can be quite involved.

Online	Offline
Last Visited	‎01-04-2017 12:29 PM

Member Since	‎10-11-2016 01:03 PM
Last Visited	‎01-04-2017 12:29 PM
Posts	5
Kudos received	2

Cloudera Community

Re: is there any way to load the csv file into pho...

Re: Is there any way to do pagination in phoenix 4...