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
