About tito765

tito765 · ‎02-13-2019

Hi @Andrew Lim, great article! Thanks a lot. I have a question. Can I do the same with BitBucket? If yes, what will be the class for bitbucket? Thanks.

tito765 · ‎09-12-2018

Hi @Vinicius Higa Murakami , Thanks for your response. It worked just executing the below query in Hive View @ Ambari. add jar hdfs:///tmp/hivexmlserde-1.0.5.3.jar; Thank you so much.. 🙂

tito765 · ‎09-11-2018

Hi @Vinicius Higa Murakami , I have included the jar in hive-site.xml with property name <hive.aux.jars.path>. my property is like below:But still from Ambari every time i need to add the jar file to execute any query. I want to write query without "add jar" each time. how can i do that? <property> <name>hive.aux.jars.path</name> <value>/tmp/hivexmlserde-1.0.5.3.jar</value> </property>

tito765 · ‎09-11-2018

Hi @Vinicius Higa Murakami , Thanks a lot. Finally it worked. The last problem was due to ” instead of " in the xml file, which was preventing Serde to read the xml file. Thank you and i do appreciate your kind help.

tito765 · ‎09-10-2018

Hi @Vinicius Higa Murakami , Thank you so much for your detailed reply. I tried all the first 3 steps except the 4th one. Now when i am executing any Select statement, getting below error: Failed to fetch next batch for the Resultset org.apache.hive.service.cli.HiveSQLException: java.io.IOException: java.lang.NullPointerException

tito765 · ‎09-07-2018

@Neeraj Sabharwal would you please look into this? i am getting error while following your article "xml and HIVE parsing". To check jar i got this: hive> list jars; /tmp/hivexmlserde-1.0.5.3.jar also executed command to see the specific class: [root@sandbox-hdp tmp]# jar -tf hivexmlserde-1.0.5.3.jar | grep -icom.ibm.spss.hive.serde2.xml.XmlInputFormat com/ibm/spss/hive/serde2/xml/XmlInputFormat$XmlRecordReader.class com/ibm/spss/hive/serde2/xml/XmlInputFormat.class

tito765 · ‎09-06-2018

I am trying to ingest a simple xml to hive table. Table is created but when executing select query on that table getting below error: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: RuntimeException java.lang.ClassNotFoundException: com.ibm.spss.hive.serde2.xml.XmlInputFormat I followed this article: https://community.hortonworks.com/content/kbentry/972/hive-and-xml-pasring.html also modified the value : hive.tez.input.format= org.apache.hadoop.hive.ql.io.CombineHiveInputFormat which was before hive.tez.input.format= org.apache.hadoop.hive.ql.io.HiveInputFormat Any help to resolve this issue greatly appreciated. Thank you. org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: RuntimeException java.lang.ClassNotFoundException: com.ibm.spss.hive.serde2.xml.XmlInputFormat

tito765 · ‎08-29-2018

@Steven Matison Thanks for the URL. Yes, it can be. At the same time i found some blogs where it is saying "Using web service call in Hive UDF is absolutely bad design" whats your opinion regarding this design issue? is there any performance issue which will be a disaster?

tito765 · ‎08-29-2018

@Steven Matison Thank you for your response. Yes, using Nifi it is doable. But i was interested to know "is it possible to call a web service through Hive UDF or any other better option in Hive?" Or Hive does not have the capability to make a web service call from Hive to external application? Can hive call a web service from Hive?

tito765 · ‎08-28-2018

The scenario is: I want to write HiveQL to query from HDFS and if certain value is found which will call a webservice to have the exact meaning of that value from a different storage outside Hadoop stack. is it possible? Can a web service call/API call is possible from Hive?

Online	Offline
Last Visited	‎03-27-2019 02:45 PM

Member Since	‎09-20-2017 07:33 PM
Last Visited	‎03-27-2019 02:45 PM
Posts	61
Kudos received	1

Cloudera Community

Re: Storing Apache NiFi Versioned Flows in a Git R...

Re: XML and Hive parsing error with Serde.

Re: XML and Hive parsing error with Serde.

Re: XML and Hive parsing error with Serde.

Re: XML and Hive parsing error with Serde.

Re: XML and Hive parsing error with Serde.

XML and Hive parsing error with Serde.

Re: Can I call a web service from hive?

Re: Can I call a web service from hive?

Can I call a web service from hive?