This I need to do from hadoop namenode? ... View more

Query : ./sqoop import --connect jdbc:oracle:thin://<ip address>:1521/app --username APP --password APP12# --table tbemp --hive-import ... View more

Great !! @Bernhard Walter . Thanks for your help. ... View more

I tried @Bernhard Walter : But I am not getting values hive> select '_c0' from xml_table; Total jobs = 1 Launching Job 1 out of 1 Number of reduce tasks is set to 0 since there's no reduce operator Starting Job = job_1461307169071_0063, Tracking URL = http://CDCUDHDOOPAPP02:8088/proxy/application_1461307169071_0063/ Kill Command = /chroot/hadoop/inst/hadoop/hadoop-2.4.0/bin/hadoop job -kill job_1461307169071_0063 Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0 2016-05-10 14:33:40,593 Stage-1 map = 0%, reduce = 0% 2016-05-10 14:33:45,811 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 0.96 sec MapReduce Total cumulative CPU time: 960 msec Ended Job = job_1461307169071_0063 MapReduce Jobs Launched: Job 0: Map: 1 Cumulative CPU: 0.96 sec HDFS Read: 265 HDFS Write: 8 SUCCESS Total MapReduce CPU Time Spent: 960 msec OK _c0 _c0 Time taken: 17.912 seconds, Fetched: 2 row(s) ... View more

@Rajkumar Singh hive> describe formatted jsont1; OK col_name data_type comment # col_name data_type comment json string # Detailed Table Information Database: logs Owner: hadoop CreateTime: Tue May 03 15:24:27 IST 2016 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Location: hdfs://mycluster:8020/jsam Table Type: EXTERNAL_TABLE Table Parameters: COLUMN_STATS_ACCURATE false EXTERNAL TRUE numFiles 0 numRows -1 rawDataSize -1 totalSize 0 transient_lastDdlTime 1462269267 # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 ... View more

@Rajkumar Singh Yes I tried this also .. getting as below FAILED: IllegalArgumentException java.net.UnknownHostException: jsam Below text to show jsam is available in hdfs : hive> dfs -ls /jsam; Found 1 items drwxr-xr-x - hadoop supergroup 0 2016-05-06 12:49 /jsam/j1 ... View more