About sktariq

sktariq · ‎11-20-2017

@Jay Kumar SenSharma Thanks for your response.Now getting another error.

sktariq · ‎11-20-2017

Thanks Jay for your response. I added all jar files in this hive location "/usr/lib/hive/lib". Now getting following error FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hive/serde2/SerD. Also you pasted following text talking about hive client lib ? is it different then hive lib? Some example jars (you might not need all those jars but some of them are needed) but some of them like osh.jar & ojdbc7.jar, ucp.jar might be needed to be present inside the hive lib and hive client lib.

sktariq · ‎11-19-2017

Hi Guys, I am new in Apache Hadoop. I want to access oracle table through Hive. I used following document for that but not able to query Data. The document is showing that I need to create external table from Hive to Oracle. In Oracle, I have all tables exist there. My assumption is that I need to only create external table (or link) http://oraclegis.com/blog/2016/09/27/oracle-datasource-for-apache-hadoop-od4h-introduction/ CREATE EXTERNAL TABLE oracle_table_HIVE STORED BY 'oracle.hcat.osh.OracleStorageHandler' TBLPROPERTIES ( 'mapreduce.jdbc.url' = 'jdbc:oracle:thin:@//hostname:1521/ORCL', 'mapreduce.jdbc.username' = 'oracle_user', 'mapreduce.jdbc.password' = 'password', 'mapreduce.jdbc.input.table.name' = 'oracle_table', 'oracle.hcat.osh.useMonitor'='true', 'oracle.hcat.osh.fetchSize'='10000', 'oracle.hcat.osh.useOracleParallelism'='true' ); Getting this error: FAILED: SemanticException Cannot find class 'oracle.hcat.osh.OracleStorageHandler'

Online	Offline
Last Visited	‎11-20-2017 10:58 PM

Date Registered	‎11-18-2017 04:48 AM
Last Visited	‎11-20-2017 10:58 PM
Total Messages Posted	3

Re: Query Oracle Table from Apache Hadoop(Hive)

Re: Query Oracle Table from Apache Hadoop(Hive)

Query Oracle Table from Apache Hadoop(Hive)