Repository: hive Updated Branches: refs/heads/master d545935a5 -> c23841e55
http://git-wip-us.apache.org/repos/asf/hive/blob/c23841e5/ql/src/test/results/clientpositive/special_character_in_tabnames_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/special_character_in_tabnames_2.q.out b/ql/src/test/results/clientpositive/special_character_in_tabnames_2.q.out new file mode 100644 index 0000000..51d31e0 --- /dev/null +++ b/ql/src/test/results/clientpositive/special_character_in_tabnames_2.q.out @@ -0,0 +1,304 @@ +PREHOOK: query: -- try the query without indexing, with manual indexing, and with automatic indexing +-- SORT_QUERY_RESULTS + +DROP TABLE IF EXISTS `s/c` +PREHOOK: type: DROPTABLE +POSTHOOK: query: -- try the query without indexing, with manual indexing, and with automatic indexing +-- SORT_QUERY_RESULTS + +DROP TABLE IF EXISTS `s/c` +POSTHOOK: type: DROPTABLE +PREHOOK: query: CREATE TABLE `s/c` (key STRING COMMENT 'default', value STRING COMMENT 'default') STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@s/c +POSTHOOK: query: CREATE TABLE `s/c` (key STRING COMMENT 'default', value STRING COMMENT 'default') STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@s/c +PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/kv1.txt" INTO TABLE `s/c` +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@s/c +POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/kv1.txt" INTO TABLE `s/c` +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@s/c +PREHOOK: query: ANALYZE TABLE `s/c` COMPUTE STATISTICS +PREHOOK: type: QUERY +PREHOOK: Input: default@s/c +PREHOOK: Output: default@s/c +POSTHOOK: query: ANALYZE TABLE `s/c` COMPUTE STATISTICS +POSTHOOK: type: QUERY +POSTHOOK: Input: default@s/c +POSTHOOK: Output: default@s/c +PREHOOK: query: ANALYZE TABLE `s/c` COMPUTE STATISTICS FOR COLUMNS key,value +PREHOOK: type: QUERY +PREHOOK: Input: default@s/c +#### A masked pattern was here #### +POSTHOOK: query: ANALYZE TABLE `s/c` COMPUTE STATISTICS FOR COLUMNS key,value +POSTHOOK: type: QUERY +POSTHOOK: Input: default@s/c +#### A masked pattern was here #### +PREHOOK: query: -- without indexing +SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@s/c +#### A masked pattern was here #### +POSTHOOK: query: -- without indexing +SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@s/c +#### A masked pattern was here #### +82 val_82 +83 val_83 +83 val_83 +84 val_84 +84 val_84 +85 val_85 +86 val_86 +87 val_87 +90 val_90 +90 val_90 +90 val_90 +92 val_92 +95 val_95 +95 val_95 +96 val_96 +97 val_97 +97 val_97 +98 val_98 +98 val_98 +PREHOOK: query: CREATE INDEX src_index ON TABLE `s/c`(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: type: CREATEINDEX +PREHOOK: Input: default@s/c +POSTHOOK: query: CREATE INDEX src_index ON TABLE `s/c`(key) as 'COMPACT' WITH DEFERRED REBUILD +POSTHOOK: type: CREATEINDEX +POSTHOOK: Input: default@s/c +POSTHOOK: Output: default@default__s/c_src_index__ +PREHOOK: query: ALTER INDEX src_index ON `s/c` REBUILD +PREHOOK: type: ALTERINDEX_REBUILD +PREHOOK: Input: default@s/c +PREHOOK: Output: default@default__s/c_src_index__ +POSTHOOK: query: ALTER INDEX src_index ON `s/c` REBUILD +POSTHOOK: type: ALTERINDEX_REBUILD +POSTHOOK: Input: default@s/c +POSTHOOK: Output: default@default__s/c_src_index__ +POSTHOOK: Lineage: default__s/c_src_index__._bucketname SIMPLE [(s/c)s/c.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: default__s/c_src_index__._offsets EXPRESSION [(s/c)s/c.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] +POSTHOOK: Lineage: default__s/c_src_index__.key SIMPLE [(s/c)s/c.FieldSchema(name:key, type:string, comment:default), ] +PREHOOK: query: -- manual indexing +#### A masked pattern was here #### +PREHOOK: type: QUERY +PREHOOK: Input: default@default__s/c_src_index__ +#### A masked pattern was here #### +POSTHOOK: query: -- manual indexing +#### A masked pattern was here #### +POSTHOOK: type: QUERY +POSTHOOK: Input: default@default__s/c_src_index__ +#### A masked pattern was here #### +PREHOOK: query: EXPLAIN SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +PREHOOK: type: QUERY +POSTHOOK: query: EXPLAIN SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: s/c + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) (type: boolean) + Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@s/c +#### A masked pattern was here #### +POSTHOOK: query: SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@s/c +#### A masked pattern was here #### +82 val_82 +83 val_83 +83 val_83 +84 val_84 +84 val_84 +85 val_85 +86 val_86 +87 val_87 +90 val_90 +90 val_90 +90 val_90 +92 val_92 +95 val_95 +95 val_95 +96 val_96 +97 val_97 +97 val_97 +98 val_98 +98 val_98 +PREHOOK: query: -- automatic indexing +EXPLAIN SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +PREHOOK: type: QUERY +POSTHOOK: query: -- automatic indexing +EXPLAIN SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-3 is a root stage + Stage-8 depends on stages: Stage-3 , consists of Stage-5, Stage-4, Stage-6 + Stage-5 + Stage-2 depends on stages: Stage-5, Stage-4, Stage-7 + Stage-1 depends on stages: Stage-2 + Stage-4 + Stage-6 + Stage-7 depends on stages: Stage-6 + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-3 + Map Reduce + Map Operator Tree: + TableScan + alias: default__s/c_src_index__ + filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) (type: boolean) + Filter Operator + predicate: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) (type: boolean) + Select Operator + expressions: _bucketname (type: string), _offsets (type: array<bigint>) + outputColumnNames: _col0, _col1 + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-8 + Conditional Operator + + Stage: Stage-5 + Move Operator + files: + hdfs directory: true +#### A masked pattern was here #### + + Stage: Stage-2 + Move Operator + files: + hdfs directory: true +#### A masked pattern was here #### + + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: s/c + filterExpr: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) (type: boolean) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: ((UDFToDouble(key) > 80.0) and (UDFToDouble(key) < 100.0)) (type: boolean) + Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: string), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-4 + Map Reduce + Map Operator Tree: + TableScan + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-6 + Map Reduce + Map Operator Tree: + TableScan + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-7 + Move Operator + files: + hdfs directory: true +#### A masked pattern was here #### + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@default__s/c_src_index__ +PREHOOK: Input: default@s/c +#### A masked pattern was here #### +POSTHOOK: query: SELECT key, value FROM `s/c` WHERE key > 80 AND key < 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@default__s/c_src_index__ +POSTHOOK: Input: default@s/c +#### A masked pattern was here #### +82 val_82 +83 val_83 +83 val_83 +84 val_84 +84 val_84 +85 val_85 +86 val_86 +87 val_87 +90 val_90 +90 val_90 +90 val_90 +92 val_92 +95 val_95 +95 val_95 +96 val_96 +97 val_97 +97 val_97 +98 val_98 +98 val_98 +PREHOOK: query: DROP INDEX src_index on `s/c` +PREHOOK: type: DROPINDEX +PREHOOK: Input: default@s/c +POSTHOOK: query: DROP INDEX src_index on `s/c` +POSTHOOK: type: DROPINDEX +POSTHOOK: Input: default@s/c