Member since
11-18-2017
3
Posts
0
Kudos Received
0
Solutions
11-20-2017
10:59 PM
@Jay Kumar SenSharma Thanks for your response.Now getting another error.
... View more
11-20-2017
10:58 PM
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.
... View more
11-19-2017
06:26 PM
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'
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
-
MapReduce