Cloudera Community
sandyy006
user rank
user rank
Guru

Re: Best practice to import data into HBase/Phoeni...

by Guru Guru in Support Questions
‎08-16-2018 06:17 PM
‎08-16-2018 06:17 PM
@Daniel Zafar The doc is bit misleading, Below command should help you in loading the hdfs csv files to phoenix table. (Note that the input path is of HDFS) HADOOP_CLASSPATH=/usr/hdp/current/hbase-client/lib/hbase-protocol.jar:/etc/hbase/conf hadoop jar /usr/hdp/current/phoenix-client/phoenix-client.jar org.apache.phoenix.mapreduce.CsvBulkLoadTool --table EXAMPLE --input /tmp/data.csv ... View more

Re: Best practice to import data into HBase/Phoeni...

by Guru Guru in Support Questions
‎08-16-2018 04:52 PM
‎08-16-2018 04:52 PM
@Daniel Zafar Since Phoenix is on top of Hbase. Data will be in Hbase in anycase. It is just that Phoenix uses its encoding while writing the data into tables. More details in this thread. ... View more

Re: Managing jars while connect Phoenix to Zeppeli...

by Guru Guru in Support Questions
‎08-16-2018 04:44 PM
1 Kudo
‎08-16-2018 04:44 PM
1 Kudo
Some jar conflicts, Try removing the phoenix-core jar from the classpath. ... View more

Re: One question about Oozie:Web show

by Guru Guru in Support Questions
‎08-16-2018 04:31 PM
‎08-16-2018 04:31 PM
Issue should be something else then, Did you try checking the logs if there is any clue in them? ... View more

Re: Best practice to import data into HBase/Phoeni...

by Guru Guru in Support Questions
‎08-16-2018 04:28 PM
‎08-16-2018 04:28 PM
@Daniel Zafar Don't forget to Accept my answer if it helped you. 🙂 ... View more

Re: Best practice to import data into HBase/Phoeni...

by Guru Guru in Support Questions
‎08-16-2018 03:17 PM
‎08-16-2018 03:17 PM
In this case, The best option i see is to use sqoop and load the data into HDFS from RDBMS (this will be a parallel copy and should be fast). Then use Phoenix Bulk loading MR job to load that HDFS data into Phoenix. ... View more

Re: QA test for ambari cluster

by Guru Guru in Support Questions
‎08-16-2018 03:11 PM
1 Kudo
‎08-16-2018 03:11 PM
1 Kudo
@Michael Bronson I think you can use Chaos Monkey which does all this stuff. (this will be at the hardware/network level but not at the hadoop components level directly) Do check this quick video demo: https://www.youtube.com/watch?v=AnSrpk_thDE ... View more

Re: One question about Oozie:Web show

by Guru Guru in Support Questions
‎08-16-2018 02:44 PM
‎08-16-2018 02:44 PM
@Xiong Duan, Are you using the default Derby database for Oozie? If yes, that could be a cause of Oozie UI slowness. Try using the external database. That should help. ... View more

Re: hello i have a procesor with this id c4305271-...

by Guru Guru in Support Questions
‎08-16-2018 09:20 AM
1 Kudo
‎08-16-2018 09:20 AM
1 Kudo
@ibrahima diattara Below API should get you the processor name. curl -i -X GET http://localhost:9090/nifi-api/flow/search-results?q=<name(or)id>; Hope this helps. ... View more

Re: Managing jars while connect Phoenix to Zeppeli...

by Guru Guru in Support Questions
‎08-16-2018 07:31 AM
1 Kudo
‎08-16-2018 07:31 AM
1 Kudo
@Daniel Zafar Additionally you'd need to add phoenix-client.jar in the classpath. jar tvf phoenix-client.jar | grep TransactionSystemClient 1548 Thu Jul 12 20:37:06 UTC 2018 org/apache/tephra/TransactionSystemClient.class Hope this helps! ... View more
Contact Me
Online
Offline
Last Visited
‎01-23-2020 02:33 AM
Community Statistics
Member Since ‎02-01-2019 10:51 AM
Last Visited ‎01-23-2020 02:33 AM
Posts 650
Kudos received 142