PageRenderTime 54ms CodeModel.GetById 52ms app.highlight 0ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/show_tables.q.out

#
text | 177 lines | 167 code | 10 blank | 0 comment | 0 complexity | 6b2bdefbd7a7cde168ed16e4663e6db6 MD5 | raw file
  1PREHOOK: query: CREATE TABLE shtb_test1(KEY STRING, VALUE STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE shtb_test1(KEY STRING, VALUE STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@shtb_test1
  6PREHOOK: query: CREATE TABLE shtb_test2(KEY STRING, VALUE STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE
  7PREHOOK: type: CREATETABLE
  8POSTHOOK: query: CREATE TABLE shtb_test2(KEY STRING, VALUE STRING) PARTITIONED BY(ds STRING) STORED AS TEXTFILE
  9POSTHOOK: type: CREATETABLE
 10POSTHOOK: Output: default@shtb_test2
 11PREHOOK: query: EXPLAIN
 12SHOW TABLES 'shtb_*'
 13PREHOOK: type: SHOWTABLES
 14POSTHOOK: query: EXPLAIN
 15SHOW TABLES 'shtb_*'
 16POSTHOOK: type: SHOWTABLES
 17ABSTRACT SYNTAX TREE:
 18  (TOK_SHOWTABLES 'shtb_*')
 19
 20STAGE DEPENDENCIES:
 21  Stage-0 is a root stage
 22  Stage-1 is a root stage
 23
 24STAGE PLANS:
 25  Stage: Stage-0
 26      Show Table Operator:
 27        Show Tables
 28          database name: default
 29          pattern: shtb_*
 30
 31  Stage: Stage-1
 32    Fetch Operator
 33      limit: -1
 34
 35
 36PREHOOK: query: SHOW TABLES 'shtb_*'
 37PREHOOK: type: SHOWTABLES
 38POSTHOOK: query: SHOW TABLES 'shtb_*'
 39POSTHOOK: type: SHOWTABLES
 40shtb_test1
 41shtb_test2
 42PREHOOK: query: EXPLAIN
 43SHOW TABLES LIKE 'shtb_test1|shtb_test2'
 44PREHOOK: type: SHOWTABLES
 45POSTHOOK: query: EXPLAIN
 46SHOW TABLES LIKE 'shtb_test1|shtb_test2'
 47POSTHOOK: type: SHOWTABLES
 48ABSTRACT SYNTAX TREE:
 49  (TOK_SHOWTABLES 'shtb_test1|shtb_test2')
 50
 51STAGE DEPENDENCIES:
 52  Stage-0 is a root stage
 53  Stage-1 is a root stage
 54
 55STAGE PLANS:
 56  Stage: Stage-0
 57      Show Table Operator:
 58        Show Tables
 59          database name: default
 60          pattern: shtb_test1|shtb_test2
 61
 62  Stage: Stage-1
 63    Fetch Operator
 64      limit: -1
 65
 66
 67PREHOOK: query: SHOW TABLES LIKE 'shtb_test1|shtb_test2'
 68PREHOOK: type: SHOWTABLES
 69POSTHOOK: query: SHOW TABLES LIKE 'shtb_test1|shtb_test2'
 70POSTHOOK: type: SHOWTABLES
 71shtb_test1
 72shtb_test2
 73PREHOOK: query: -- SHOW TABLES FROM/IN database
 74CREATE DATABASE test_db
 75PREHOOK: type: CREATEDATABASE
 76POSTHOOK: query: -- SHOW TABLES FROM/IN database
 77CREATE DATABASE test_db
 78POSTHOOK: type: CREATEDATABASE
 79PREHOOK: query: USE test_db
 80PREHOOK: type: SWITCHDATABASE
 81POSTHOOK: query: USE test_db
 82POSTHOOK: type: SWITCHDATABASE
 83PREHOOK: query: CREATE TABLE foo(a INT)
 84PREHOOK: type: CREATETABLE
 85POSTHOOK: query: CREATE TABLE foo(a INT)
 86POSTHOOK: type: CREATETABLE
 87POSTHOOK: Output: test_db@foo
 88PREHOOK: query: CREATE TABLE bar(a INT)
 89PREHOOK: type: CREATETABLE
 90POSTHOOK: query: CREATE TABLE bar(a INT)
 91POSTHOOK: type: CREATETABLE
 92POSTHOOK: Output: test_db@bar
 93PREHOOK: query: CREATE TABLE baz(a INT)
 94PREHOOK: type: CREATETABLE
 95POSTHOOK: query: CREATE TABLE baz(a INT)
 96POSTHOOK: type: CREATETABLE
 97POSTHOOK: Output: test_db@baz
 98PREHOOK: query: -- SHOW TABLES basic syntax tests
 99USE default
100PREHOOK: type: SWITCHDATABASE
101POSTHOOK: query: -- SHOW TABLES basic syntax tests
102USE default
103POSTHOOK: type: SWITCHDATABASE
104PREHOOK: query: SHOW TABLES FROM test_db
105PREHOOK: type: SHOWTABLES
106POSTHOOK: query: SHOW TABLES FROM test_db
107POSTHOOK: type: SHOWTABLES
108bar
109baz
110foo
111PREHOOK: query: SHOW TABLES FROM default
112PREHOOK: type: SHOWTABLES
113POSTHOOK: query: SHOW TABLES FROM default
114POSTHOOK: type: SHOWTABLES
115shtb_test1
116shtb_test2
117src
118src1
119src_json
120src_sequencefile
121src_thrift
122srcbucket
123srcbucket2
124srcpart
125PREHOOK: query: SHOW TABLES IN test_db
126PREHOOK: type: SHOWTABLES
127POSTHOOK: query: SHOW TABLES IN test_db
128POSTHOOK: type: SHOWTABLES
129bar
130baz
131foo
132PREHOOK: query: SHOW TABLES IN default
133PREHOOK: type: SHOWTABLES
134POSTHOOK: query: SHOW TABLES IN default
135POSTHOOK: type: SHOWTABLES
136shtb_test1
137shtb_test2
138src
139src1
140src_json
141src_sequencefile
142src_thrift
143srcbucket
144srcbucket2
145srcpart
146PREHOOK: query: SHOW TABLES IN test_db "test*"
147PREHOOK: type: SHOWTABLES
148POSTHOOK: query: SHOW TABLES IN test_db "test*"
149POSTHOOK: type: SHOWTABLES
150PREHOOK: query: SHOW TABLES IN test_db LIKE "nomatch"
151PREHOOK: type: SHOWTABLES
152POSTHOOK: query: SHOW TABLES IN test_db LIKE "nomatch"
153POSTHOOK: type: SHOWTABLES
154PREHOOK: query: -- SHOW TABLES from a database with a name that requires escaping
155CREATE DATABASE `database`
156PREHOOK: type: CREATEDATABASE
157POSTHOOK: query: -- SHOW TABLES from a database with a name that requires escaping
158CREATE DATABASE `database`
159POSTHOOK: type: CREATEDATABASE
160PREHOOK: query: USE `database`
161PREHOOK: type: SWITCHDATABASE
162POSTHOOK: query: USE `database`
163POSTHOOK: type: SWITCHDATABASE
164PREHOOK: query: CREATE TABLE foo(a INT)
165PREHOOK: type: CREATETABLE
166POSTHOOK: query: CREATE TABLE foo(a INT)
167POSTHOOK: type: CREATETABLE
168POSTHOOK: Output: database@foo
169PREHOOK: query: USE default
170PREHOOK: type: SWITCHDATABASE
171POSTHOOK: query: USE default
172POSTHOOK: type: SWITCHDATABASE
173PREHOOK: query: SHOW TABLES FROM `database` LIKE "foo"
174PREHOOK: type: SHOWTABLES
175POSTHOOK: query: SHOW TABLES FROM `database` LIKE "foo"
176POSTHOOK: type: SHOWTABLES
177foo