Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive uploading


Copy link to this message
-
RE: Hive uploading
there was no any hive-site.xml when I extracted it.

although I am able to create tables in Hive, uploading data from HDFS to hive by using

LOAD DATA INPATH 'hdfs://localhost:9000/user/hive/warehouse/dummyhive/part-m-00000' OVERWRITE INTO TABLE demoo PARTITION (ROLL = 001);

Loading data to table default.demoo partition (roll=001)
OK
Time taken: 0.466 seconds

and able to see records..

tmp/mediaadmin/hive_job_log_mediaadmin_201207051849_2011545354.txt contains

SessionStart SESSION_ID="mediaadmin_201207051849" TIME="1341494353320"
QueryStart QUERY_STRING="CREATE TABLE `yeshivee` ( `no` INT, `name` STRING) COMMENT 'Imported by sqoop on 2012/07/05 18:49:11' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE" QUERY_ID="mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872" TIME="1341494353751"
Counters plan="{"queryId":"mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872","queryType":null,"queryAttributes":{"queryString":"CREATE TABLE `yeshivee` ( `no` INT, `name` STRING) COMMENT 'Imported by sqoop on 2012/07/05 18:49:11' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"false","started":"false"}],"done":"false","started":"false"}],"done":"false","started":"true"}" TIME="1341494353762"
TaskStart TASK_NAME="org.apache.hadoop.hive.ql.exec.DDLTask" TASK_ID="Stage-0" QUERY_ID="mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872" TIME="1341494353766"
Counters plan="{"queryId":"mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872","queryType":null,"queryAttributes":{"queryString":"CREATE TABLE `yeshivee` ( `no` INT, `name` STRING) COMMENT 'Imported by sqoop on 2012/07/05 18:49:11' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"false","started":"true"}],"done":"false","started":"true"}],"done":"false","started":"true"}" TIME="1341494353768"
Counters plan="{"queryId":"mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872","queryType":null,"queryAttributes":{"queryString":"CREATE TABLE `yeshivee` ( `no` INT, `name` STRING) COMMENT 'Imported by sqoop on 2012/07/05 18:49:11' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"true","started":"true"}],"done":"true","started":"true"}],"done":"false","started":"true"}" TIME="1341494357307"
TaskEnd TASK_RET_CODE="0" TASK_NAME="org.apache.hadoop.hive.ql.exec.DDLTask" TASK_ID="Stage-0" QUERY_ID="mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872" TIME="1341494357307"
QueryEnd QUERY_STRING="CREATE TABLE `yeshivee` ( `no` INT, `name` STRING) COMMENT 'Imported by sqoop on 2012/07/05 18:49:11' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE" QUERY_ID="mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872" QUERY_RET_CODE="0" QUERY_NUM_TASKS="0" TIME="1341494357363"
Counters plan="{"queryId":"mediaadmin_20120705184949_24437ec0-3332-49ea-851c-3ba8a3d5c872","queryType":null,"queryAttributes":{"queryString":"CREATE TABLE `yeshivee` ( `no` INT, `name` STRING) COMMENT 'Imported by sqoop on 2012/07/05 18:49:11' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' LINES TERMINATED BY '\012' STORED AS TEXTFILE"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"DDL","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"true","started":"true"}],"done":"true","started":"true"}],"done":"true","started":"true"}" TIME="1341494357364"
QueryStart QUERY_STRING=" LOAD DATA INPATH 'hdfs://localhost:9000/userdata/yogesh/sqoop/imports/yesrdbms1' INTO TABLE `yeshivee`" QUERY_ID="mediaadmin_20120705184949_72d256c3-1698-40db-a8d6-6536512dbd63" TIME="1341494357502"
Counters plan="{"queryId":"mediaadmin_20120705184949_72d256c3-1698-40db-a8d6-6536512dbd63","queryType":null,"queryAttributes":{"queryString":" LOAD DATA INPATH 'hdfs://localhost:9000/userdata/yogesh/sqoop/imports/yesrdbms1' INTO TABLE `yeshivee`"},"queryCounters":"null","stageGraph":{"nodeType":"STAGE","roots":"null","adjacencyList":"]"},"stageList":[{"stageId":"Stage-0","stageType":"MOVE","stageAttributes":"null","stageCounters":"}","taskList":[{"taskId":"Stage-0_OTHER","taskType":"OTHER","taskAttributes":"null","taskCounters":"null","operatorGraph":"null","operatorList":"]","done":"false","started":"false"}],"done":"false","started":"false"}],"done":"false","started":"true"}" TIME="1341494357502"
TaskStart TASK_NAME="org.apache.hadoop.hive.ql.exec.MoveTask" TASK_ID="Stage-0" QUERY_ID="mediaadmin_20120705184949_72d256c3-1698-40db-a8d6-6536512dbd63" TIME="1341494357502"
Counters plan="{"queryId":"mediaadmin_20120705184949_72d256c3-1698-40db-a8d6-6536512dbd63","queryType":null,"queryAttributes":{