On 07/03/12 18:01, Jarek Jarcec Cecho wrote:
It's hard for me to guess what happened. Would you mind providing log file with
--verbose flag set?
Here - I've attached sqoop verbose log as well as hive job output log
(the one present in the sqoop logs)
Hope this helps with the problem.
Marcin
12/03/08 08:27:27 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
12/03/08 08:27:27 WARN tool.BaseSqoopTool: Hive does not support escape
characters in fields;
12/03/08 08:27:27 WARN tool.BaseSqoopTool: parse errors in Hive may result from
using --escaped-by.
12/03/08 08:27:27 WARN tool.BaseSqoopTool: Hive does not support quoted
strings; parse errors
12/03/08 08:27:27 WARN tool.BaseSqoopTool: in Hive may result from using
--enclosed-by.
12/03/08 08:27:27 INFO manager.SqlManager: Using default fetchSize of 1000
12/03/08 08:27:27 INFO tool.CodeGenTool: Beginning code generation
12/03/08 08:27:28 INFO manager.SqlManager: Executing SQL statement: select *
from all_tables where (1 = 0)
12/03/08 08:27:28 INFO manager.SqlManager: Executing SQL statement: select *
from all_tables where (1 = 0)
12/03/08 08:27:28 INFO orm.CompilationManager: HADOOP_HOME is
/usr/lib/hadoop-1.0.0/libexec/..
Note:
/tmp/sqoop-michler/compile/cb7fa3307b66de04bd748a36c9108e44/QueryResult.java
uses or overrides a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
12/03/08 08:27:30 ERROR orm.CompilationManager: Could not rename
/tmp/sqoop-michler/compile/cb7fa3307b66de04bd748a36c9108e44/QueryResult.java to
/home/michler/sqoop-1.4.1-incubating__hadoop-1.0.0/./QueryResult.java
java.io.IOException: Destination
'/home/michler/sqoop-1.4.1-incubating__hadoop-1.0.0/./QueryResult.java' already
exists
at org.apache.commons.io.FileUtils.moveFile(FileUtils.java:1811)
at
org.apache.sqoop.orm.CompilationManager.compile(CompilationManager.java:227)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:83)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)
12/03/08 08:27:30 INFO orm.CompilationManager: Writing jar file:
/tmp/sqoop-michler/compile/cb7fa3307b66de04bd748a36c9108e44/QueryResult.jar
12/03/08 08:27:30 INFO mapreduce.ImportJobBase: Beginning query import.
12/03/08 08:27:32 INFO mapred.JobClient: Running job: job_201203071602_0006
12/03/08 08:27:33 INFO mapred.JobClient: map 0% reduce 0%
12/03/08 08:27:40 INFO mapred.JobClient: map 50% reduce 0%
12/03/08 08:27:45 INFO mapred.JobClient: map 100% reduce 0%
12/03/08 08:27:57 INFO mapred.JobClient: Counters: 18
12/03/08 08:27:57 INFO mapred.JobClient: Job Counters
12/03/08 08:27:57 INFO mapred.JobClient: SLOTS_MILLIS_MAPS=17716
12/03/08 08:27:57 INFO mapred.JobClient: Total time spent by all reduces
waiting after reserving slots (ms)=0
12/03/08 08:27:57 INFO mapred.JobClient: Total time spent by all maps
waiting after reserving slots (ms)=0
12/03/08 08:27:57 INFO mapred.JobClient: Launched map tasks=1
12/03/08 08:27:57 INFO mapred.JobClient: SLOTS_MILLIS_REDUCES=0
12/03/08 08:27:57 INFO mapred.JobClient: File Output Format Counters
12/03/08 08:27:57 INFO mapred.JobClient: Bytes Written=28941
12/03/08 08:27:57 INFO mapred.JobClient: FileSystemCounters
12/03/08 08:27:57 INFO mapred.JobClient: HDFS_BYTES_READ=87
12/03/08 08:27:57 INFO mapred.JobClient: FILE_BYTES_WRITTEN=30377
12/03/08 08:27:57 INFO mapred.JobClient: HDFS_BYTES_WRITTEN=28941
12/03/08 08:27:57 INFO mapred.JobClient: File Input Format Counters
12/03/08 08:27:57 INFO mapred.JobClient: Bytes Read=0
12/03/08 08:27:57 INFO mapred.JobClient: Map-Reduce Framework
12/03/08 08:27:57 INFO mapred.JobClient: Map input records=95
12/03/08 08:27:57 INFO mapred.JobClient: Physical memory (bytes)
snapshot=104050688
12/03/08 08:27:57 INFO mapred.JobClient: Spilled Records=0
12/03/08 08:27:57 INFO mapred.JobClient: CPU time spent (ms)=2690
12/03/08 08:27:57 INFO mapred.JobClient: Total committed heap usage
(bytes)=93650944
12/03/08 08:27:57 INFO mapred.JobClient: Virtual memory (bytes)
snapshot=621776896
12/03/08 08:27:57 INFO mapred.JobClient: Map output records=95
12/03/08 08:27:57 INFO mapred.JobClient: SPLIT_RAW_BYTES=87
12/03/08 08:27:57 INFO mapreduce.ImportJobBase: Transferred 28.2627 KB in
27.2465 seconds (1.0373 KB/sec)
12/03/08 08:27:57 INFO mapreduce.ImportJobBase: Retrieved 95 records.
12/03/08 08:27:57 INFO hive.HiveImport: Removing temporary files from import
process: sample_trm12/_logs
12/03/08 08:27:57 INFO hive.HiveImport: Loading uploaded data into Hive
12/03/08 08:27:58 INFO manager.SqlManager: Executing SQL statement: select *
from all_tables where (1 = 0)
12/03/08 08:27:58 INFO manager.SqlManager: Executing SQL statement: select *
from all_tables where (1 = 0)
12/03/08 08:27:58 WARN hive.TableDefWriter: Column PCT_FREE had to be cast to a
less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column PCT_USED had to be cast to a
less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column INI_TRANS had to be cast to
a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column MAX_TRANS had to be cast to
a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column INITIAL_EXTENT had to be
cast to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column NEXT_EXTENT had to be cast
to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column MIN_EXTENTS had to be cast
to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column MAX_EXTENTS had to be cast
to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column PCT_INCREASE had to be cast
to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column FREELISTS had to be cast to
a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column FREELIST_GROUPS had to be
cast to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column NUM_ROWS had to be cast to a
less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column BLOCKS had to be cast to a
less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column EMPTY_BLOCKS had to be cast
to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column AVG_SPACE had to be cast to
a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column CHAIN_CNT had to be cast to
a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column AVG_ROW_LEN had to be cast
to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column AVG_SPACE_FREELIST_BLOCKS
had to be cast to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column NUM_FREELIST_BLOCKS had to
be cast to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column SAMPLE_SIZE had to be cast
to a less precise type in Hive
12/03/08 08:27:58 WARN hive.TableDefWriter: Column LAST_ANALYZED had to be cast
to a less precise type in Hive
12/03/08 08:28:00 INFO hive.HiveImport: WARNING:
org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use
org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
12/03/08 08:28:00 INFO hive.HiveImport: Logging initialized using configuration
in
jar:file:/home/michler/hive/lib/hive-common-0.9.0-SNAPSHOT.jar!/hive-log4j.properties
12/03/08 08:28:00 INFO hive.HiveImport: Hive history
file=/tmp/michler/hive_job_log_michler_201203080828_925626757.txt
12/03/08 08:28:06 INFO hive.HiveImport: OK
12/03/08 08:28:06 INFO hive.HiveImport: Time taken: 5.331 seconds
12/03/08 08:28:06 INFO hive.HiveImport: Loading data to table
default.sample_trm12
12/03/08 08:28:06 INFO hive.HiveImport: OK
12/03/08 08:28:06 INFO hive.HiveImport: Time taken: 0.453 seconds
12/03/08 08:28:06 INFO hive.HiveImport: Hive import complete.
SessionStart SESSION_ID="michler_201203080828" TIME="1331191680799"
QueryStart QUERY_STRING="CREATE TABLE IF NOT EXISTS `sample_trm12` ( `OWNER`
STRING, `TABLE_NAME` STRING, `TABLESPACE_NAME` STRING, `CLUSTER_NAME` STRING,
`IOT_NAME` STRING, `STATUS` STRING, `PCT_FREE` DOUBLE, `PCT_USED` DOUBLE,
`INI_TRANS` DOUBLE, `MAX_TRANS` DOUBLE, `INITIAL_EXTENT` DOUBLE, `NEXT_EXTENT`
DOUBLE, `MIN_EXTENTS` DOUBLE, `MAX_EXTENTS` DOUBLE, `PCT_INCREASE` DOUBLE,
`FREELISTS` DOUBLE, `FREELIST_GROUPS` DOUBLE, `LOGGING` STRING, `BACKED_UP`
STRING, `NUM_ROWS` DOUBLE, `BLOCKS` DOUBLE, `EMPTY_BLOCKS` DOUBLE, `AVG_SPACE`
DOUBLE, `CHAIN_CNT` DOUBLE, `AVG_ROW_LEN` DOUBLE, `AVG_SPACE_FREELIST_BLOCKS`
DOUBLE, `NUM_FREELIST_BLOCKS` DOUBLE, `DEGREE` STRING, `INSTANCES` STRING,
`CACHE` STRING, `TABLE_LOCK` STRING, `SAMPLE_SIZE` DOUBLE, `LAST_ANALYZED`
STRING, `PARTITIONED` STRING, `IOT_TYPE` STRING, `TEMPORARY` STRING,
`SECONDARY` STRING, `NESTED` STRING, `BUFFER_POOL` STRING, `FLASH_CACHE`
STRING, `CELL_FLASH_CACHE` STRING, `ROW_MOVEMENT` STRING, `GLOBAL_STATS`
STRING, `USER_STATS` STRING, `DURATION` STRING, `SKIP_CORRUPT` STRING,
`MONITORING` STRING, `CLUSTER_OWNER` STRING, `DEPENDENCIES` STRING,
`COMPRESSION` STRING, `COMPRESS_FOR` STRING, `DROPPED` STRING, `READ_ONLY`
STRING, `SEGMENT_CREATED` STRING, `RESULT_CACHE` STRING) COMMENT 'Imported by
sqoop on 2012/03/08 08:27:58' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054'
LINES TERMINATED BY '\012' STORED AS TEXTFILE"
QUERY_ID="michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003"
TIME="1331191685710"
Counters
plan="{"queryId":"michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003","queryType":null,"queryAttributes":{"queryString":"CREATE
TABLE IF NOT EXISTS `sample_trm12` ( `OWNER` STRING, `TABLE_NAME` STRING,
`TABLESPACE_NAME` STRING, `CLUSTER_NAME` STRING, `IOT_NAME` STRING, `STATUS`
STRING, `PCT_FREE` DOUBLE, `PCT_USED` DOUBLE, `INI_TRANS` DOUBLE, `MAX_TRANS`
DOUBLE, `INITIAL_EXTENT` DOUBLE, `NEXT_EXTENT` DOUBLE, `MIN_EXTENTS` DOUBLE,
`MAX_EXTENTS` DOUBLE, `PCT_INCREASE` DOUBLE, `FREELISTS` DOUBLE,
`FREELIST_GROUPS` DOUBLE, `LOGGING` STRING, `BACKED_UP` STRING, `NUM_ROWS`
DOUBLE, `BLOCKS` DOUBLE, `EMPTY_BLOCKS` DOUBLE, `AVG_SPACE` DOUBLE, `CHAIN_CNT`
DOUBLE, `AVG_ROW_LEN` DOUBLE, `AVG_SPACE_FREELIST_BLOCKS` DOUBLE,
`NUM_FREELIST_BLOCKS` DOUBLE, `DEGREE` STRING, `INSTANCES` STRING, `CACHE`
STRING, `TABLE_LOCK` STRING, `SAMPLE_SIZE` DOUBLE, `LAST_ANALYZED` STRING,
`PARTITIONED` STRING, `IOT_TYPE` STRING, `TEMPORARY` STRING, `SECONDARY`
STRING, `NESTED` STRING, `BUFFER_POOL` STRING, `FLASH_CACHE` STRING,
`CELL_FLASH_CACHE` STRING, `ROW_MOVEMENT` STRING, `GLOBAL_STATS` STRING,
`USER_STATS` STRING, `DURATION` STRING, `SKIP_CORRUPT` STRING, `MONITORING`
STRING, `CLUSTER_OWNER` STRING, `DEPENDENCIES` STRING, `COMPRESSION` STRING,
`COMPRESS_FOR` STRING, `DROPPED` STRING, `READ_ONLY` STRING, `SEGMENT_CREATED`
STRING, `RESULT_CACHE` STRING) COMMENT 'Imported by sqoop on 2012/03/08
08:27:58' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054' 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="1331191685723"
TaskStart TASK_NAME="org.apache.hadoop.hive.ql.exec.DDLTask" TASK_ID="Stage-0"
QUERY_ID="michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003"
TIME="1331191685728"
Counters
plan="{"queryId":"michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003","queryType":null,"queryAttributes":{"queryString":"CREATE
TABLE IF NOT EXISTS `sample_trm12` ( `OWNER` STRING, `TABLE_NAME` STRING,
`TABLESPACE_NAME` STRING, `CLUSTER_NAME` STRING, `IOT_NAME` STRING, `STATUS`
STRING, `PCT_FREE` DOUBLE, `PCT_USED` DOUBLE, `INI_TRANS` DOUBLE, `MAX_TRANS`
DOUBLE, `INITIAL_EXTENT` DOUBLE, `NEXT_EXTENT` DOUBLE, `MIN_EXTENTS` DOUBLE,
`MAX_EXTENTS` DOUBLE, `PCT_INCREASE` DOUBLE, `FREELISTS` DOUBLE,
`FREELIST_GROUPS` DOUBLE, `LOGGING` STRING, `BACKED_UP` STRING, `NUM_ROWS`
DOUBLE, `BLOCKS` DOUBLE, `EMPTY_BLOCKS` DOUBLE, `AVG_SPACE` DOUBLE, `CHAIN_CNT`
DOUBLE, `AVG_ROW_LEN` DOUBLE, `AVG_SPACE_FREELIST_BLOCKS` DOUBLE,
`NUM_FREELIST_BLOCKS` DOUBLE, `DEGREE` STRING, `INSTANCES` STRING, `CACHE`
STRING, `TABLE_LOCK` STRING, `SAMPLE_SIZE` DOUBLE, `LAST_ANALYZED` STRING,
`PARTITIONED` STRING, `IOT_TYPE` STRING, `TEMPORARY` STRING, `SECONDARY`
STRING, `NESTED` STRING, `BUFFER_POOL` STRING, `FLASH_CACHE` STRING,
`CELL_FLASH_CACHE` STRING, `ROW_MOVEMENT` STRING, `GLOBAL_STATS` STRING,
`USER_STATS` STRING, `DURATION` STRING, `SKIP_CORRUPT` STRING, `MONITORING`
STRING, `CLUSTER_OWNER` STRING, `DEPENDENCIES` STRING, `COMPRESSION` STRING,
`COMPRESS_FOR` STRING, `DROPPED` STRING, `READ_ONLY` STRING, `SEGMENT_CREATED`
STRING, `RESULT_CACHE` STRING) COMMENT 'Imported by sqoop on 2012/03/08
08:27:58' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054' 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="1331191685730"
Counters
plan="{"queryId":"michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003","queryType":null,"queryAttributes":{"queryString":"CREATE
TABLE IF NOT EXISTS `sample_trm12` ( `OWNER` STRING, `TABLE_NAME` STRING,
`TABLESPACE_NAME` STRING, `CLUSTER_NAME` STRING, `IOT_NAME` STRING, `STATUS`
STRING, `PCT_FREE` DOUBLE, `PCT_USED` DOUBLE, `INI_TRANS` DOUBLE, `MAX_TRANS`
DOUBLE, `INITIAL_EXTENT` DOUBLE, `NEXT_EXTENT` DOUBLE, `MIN_EXTENTS` DOUBLE,
`MAX_EXTENTS` DOUBLE, `PCT_INCREASE` DOUBLE, `FREELISTS` DOUBLE,
`FREELIST_GROUPS` DOUBLE, `LOGGING` STRING, `BACKED_UP` STRING, `NUM_ROWS`
DOUBLE, `BLOCKS` DOUBLE, `EMPTY_BLOCKS` DOUBLE, `AVG_SPACE` DOUBLE, `CHAIN_CNT`
DOUBLE, `AVG_ROW_LEN` DOUBLE, `AVG_SPACE_FREELIST_BLOCKS` DOUBLE,
`NUM_FREELIST_BLOCKS` DOUBLE, `DEGREE` STRING, `INSTANCES` STRING, `CACHE`
STRING, `TABLE_LOCK` STRING, `SAMPLE_SIZE` DOUBLE, `LAST_ANALYZED` STRING,
`PARTITIONED` STRING, `IOT_TYPE` STRING, `TEMPORARY` STRING, `SECONDARY`
STRING, `NESTED` STRING, `BUFFER_POOL` STRING, `FLASH_CACHE` STRING,
`CELL_FLASH_CACHE` STRING, `ROW_MOVEMENT` STRING, `GLOBAL_STATS` STRING,
`USER_STATS` STRING, `DURATION` STRING, `SKIP_CORRUPT` STRING, `MONITORING`
STRING, `CLUSTER_OWNER` STRING, `DEPENDENCIES` STRING, `COMPRESSION` STRING,
`COMPRESS_FOR` STRING, `DROPPED` STRING, `READ_ONLY` STRING, `SEGMENT_CREATED`
STRING, `RESULT_CACHE` STRING) COMMENT 'Imported by sqoop on 2012/03/08
08:27:58' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054' 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="1331191686372"
TaskEnd TASK_RET_CODE="0" TASK_NAME="org.apache.hadoop.hive.ql.exec.DDLTask"
TASK_ID="Stage-0"
QUERY_ID="michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003"
TIME="1331191686372"
QueryEnd QUERY_STRING="CREATE TABLE IF NOT EXISTS `sample_trm12` ( `OWNER`
STRING, `TABLE_NAME` STRING, `TABLESPACE_NAME` STRING, `CLUSTER_NAME` STRING,
`IOT_NAME` STRING, `STATUS` STRING, `PCT_FREE` DOUBLE, `PCT_USED` DOUBLE,
`INI_TRANS` DOUBLE, `MAX_TRANS` DOUBLE, `INITIAL_EXTENT` DOUBLE, `NEXT_EXTENT`
DOUBLE, `MIN_EXTENTS` DOUBLE, `MAX_EXTENTS` DOUBLE, `PCT_INCREASE` DOUBLE,
`FREELISTS` DOUBLE, `FREELIST_GROUPS` DOUBLE, `LOGGING` STRING, `BACKED_UP`
STRING, `NUM_ROWS` DOUBLE, `BLOCKS` DOUBLE, `EMPTY_BLOCKS` DOUBLE, `AVG_SPACE`
DOUBLE, `CHAIN_CNT` DOUBLE, `AVG_ROW_LEN` DOUBLE, `AVG_SPACE_FREELIST_BLOCKS`
DOUBLE, `NUM_FREELIST_BLOCKS` DOUBLE, `DEGREE` STRING, `INSTANCES` STRING,
`CACHE` STRING, `TABLE_LOCK` STRING, `SAMPLE_SIZE` DOUBLE, `LAST_ANALYZED`
STRING, `PARTITIONED` STRING, `IOT_TYPE` STRING, `TEMPORARY` STRING,
`SECONDARY` STRING, `NESTED` STRING, `BUFFER_POOL` STRING, `FLASH_CACHE`
STRING, `CELL_FLASH_CACHE` STRING, `ROW_MOVEMENT` STRING, `GLOBAL_STATS`
STRING, `USER_STATS` STRING, `DURATION` STRING, `SKIP_CORRUPT` STRING,
`MONITORING` STRING, `CLUSTER_OWNER` STRING, `DEPENDENCIES` STRING,
`COMPRESSION` STRING, `COMPRESS_FOR` STRING, `DROPPED` STRING, `READ_ONLY`
STRING, `SEGMENT_CREATED` STRING, `RESULT_CACHE` STRING) COMMENT 'Imported by
sqoop on 2012/03/08 08:27:58' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054'
LINES TERMINATED BY '\012' STORED AS TEXTFILE"
QUERY_ID="michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003"
QUERY_RET_CODE="0" QUERY_NUM_TASKS="0" TIME="1331191686390"
Counters
plan="{"queryId":"michler_20120308082828_e78e43e0-d582-41e3-973c-34ad37b49003","queryType":null,"queryAttributes":{"queryString":"CREATE
TABLE IF NOT EXISTS `sample_trm12` ( `OWNER` STRING, `TABLE_NAME` STRING,
`TABLESPACE_NAME` STRING, `CLUSTER_NAME` STRING, `IOT_NAME` STRING, `STATUS`
STRING, `PCT_FREE` DOUBLE, `PCT_USED` DOUBLE, `INI_TRANS` DOUBLE, `MAX_TRANS`
DOUBLE, `INITIAL_EXTENT` DOUBLE, `NEXT_EXTENT` DOUBLE, `MIN_EXTENTS` DOUBLE,
`MAX_EXTENTS` DOUBLE, `PCT_INCREASE` DOUBLE, `FREELISTS` DOUBLE,
`FREELIST_GROUPS` DOUBLE, `LOGGING` STRING, `BACKED_UP` STRING, `NUM_ROWS`
DOUBLE, `BLOCKS` DOUBLE, `EMPTY_BLOCKS` DOUBLE, `AVG_SPACE` DOUBLE, `CHAIN_CNT`
DOUBLE, `AVG_ROW_LEN` DOUBLE, `AVG_SPACE_FREELIST_BLOCKS` DOUBLE,
`NUM_FREELIST_BLOCKS` DOUBLE, `DEGREE` STRING, `INSTANCES` STRING, `CACHE`
STRING, `TABLE_LOCK` STRING, `SAMPLE_SIZE` DOUBLE, `LAST_ANALYZED` STRING,
`PARTITIONED` STRING, `IOT_TYPE` STRING, `TEMPORARY` STRING, `SECONDARY`
STRING, `NESTED` STRING, `BUFFER_POOL` STRING, `FLASH_CACHE` STRING,
`CELL_FLASH_CACHE` STRING, `ROW_MOVEMENT` STRING, `GLOBAL_STATS` STRING,
`USER_STATS` STRING, `DURATION` STRING, `SKIP_CORRUPT` STRING, `MONITORING`
STRING, `CLUSTER_OWNER` STRING, `DEPENDENCIES` STRING, `COMPRESSION` STRING,
`COMPRESS_FOR` STRING, `DROPPED` STRING, `READ_ONLY` STRING, `SEGMENT_CREATED`
STRING, `RESULT_CACHE` STRING) COMMENT 'Imported by sqoop on 2012/03/08
08:27:58' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\054' 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="1331191686390"
QueryStart QUERY_STRING=" LOAD DATA INPATH
'hdfs://hadoop1:9000/user/michler/sample_trm12' INTO TABLE `sample_trm12`"
QUERY_ID="michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320"
TIME="1331191686606"
Counters
plan="{"queryId":"michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320","queryType":null,"queryAttributes":{"queryString":"
LOAD DATA INPATH 'hdfs://hadoop1:9000/user/michler/sample_trm12' INTO TABLE
`sample_trm12`"},"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="1331191686606"
TaskStart TASK_NAME="org.apache.hadoop.hive.ql.exec.MoveTask" TASK_ID="Stage-0"
QUERY_ID="michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320"
TIME="1331191686606"
Counters
plan="{"queryId":"michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320","queryType":null,"queryAttributes":{"queryString":"
LOAD DATA INPATH 'hdfs://hadoop1:9000/user/michler/sample_trm12' INTO TABLE
`sample_trm12`"},"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":"true"}],"done":"false","started":"true"}],"done":"false","started":"true"}"
TIME="1331191686607"
Counters
plan="{"queryId":"michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320","queryType":null,"queryAttributes":{"queryString":"
LOAD DATA INPATH 'hdfs://hadoop1:9000/user/michler/sample_trm12' INTO TABLE
`sample_trm12`"},"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":"true","started":"true"}],"done":"true","started":"true"}],"done":"false","started":"true"}"
TIME="1331191686839"
TaskEnd TASK_RET_CODE="0" TASK_NAME="org.apache.hadoop.hive.ql.exec.MoveTask"
TASK_ID="Stage-0"
QUERY_ID="michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320"
TIME="1331191686839"
QueryEnd QUERY_STRING=" LOAD DATA INPATH
'hdfs://hadoop1:9000/user/michler/sample_trm12' INTO TABLE `sample_trm12`"
QUERY_ID="michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320"
QUERY_RET_CODE="0" QUERY_NUM_TASKS="0" TIME="1331191686839"
Counters
plan="{"queryId":"michler_20120308082828_34b8a48b-d10a-44b9-bb21-c78866a85320","queryType":null,"queryAttributes":{"queryString":"
LOAD DATA INPATH 'hdfs://hadoop1:9000/user/michler/sample_trm12' INTO TABLE
`sample_trm12`"},"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":"true","started":"true"}],"done":"true","started":"true"}],"done":"true","started":"true"}"
TIME="1331191686839"
