-
Notifications
You must be signed in to change notification settings - Fork 4.8k
Expand file tree
/
Copy pathshow_columns_like.q.out
More file actions
116 lines (116 loc) · 4.33 KB
/
Copy pathshow_columns_like.q.out
File metadata and controls
116 lines (116 loc) · 4.33 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
PREHOOK: query: CREATE DATABASE IF NOT EXISTS col_test_db
PREHOOK: type: CREATEDATABASE
PREHOOK: Output: database:col_test_db
POSTHOOK: query: CREATE DATABASE IF NOT EXISTS col_test_db
POSTHOOK: type: CREATEDATABASE
POSTHOOK: Output: database:col_test_db
PREHOOK: query: USE col_test_db
PREHOOK: type: SWITCHDATABASE
PREHOOK: Input: database:col_test_db
POSTHOOK: query: USE col_test_db
POSTHOOK: type: SWITCHDATABASE
POSTHOOK: Input: database:col_test_db
PREHOOK: query: CREATE TABLE wildcard_table (
id_primary INT,
id_secondary INT,
name_first STRING,
name_last STRING,
MixedCaseColumn INT,
another_Mixed_Col STRING
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: col_test_db@wildcard_table
PREHOOK: Output: database:col_test_db
POSTHOOK: query: CREATE TABLE wildcard_table (
id_primary INT,
id_secondary INT,
name_first STRING,
name_last STRING,
MixedCaseColumn INT,
another_Mixed_Col STRING
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: col_test_db@wildcard_table
POSTHOOK: Output: database:col_test_db
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id%'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id%'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
id_primary
id_secondary
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'name_%'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'name_%'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
name_first
name_last
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'mixedcase%'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'mixedcase%'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
mixedcasecolumn
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'another_mixed_col'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'another_mixed_col'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
another_mixed_col
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id*'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id*'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
id_primary
id_secondary
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id_primary|name_first'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id_primary|name_first'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
id_primary
name_first
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id_secondar_'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id_secondar_'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
id_secondary
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id__rimary'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id__rimary'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
id_primary
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'abc%'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'abc%'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
PREHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id__'
PREHOOK: type: SHOWCOLUMNS
PREHOOK: Input: col_test_db@wildcard_table
POSTHOOK: query: SHOW COLUMNS FROM wildcard_table LIKE 'id__'
POSTHOOK: type: SHOWCOLUMNS
POSTHOOK: Input: col_test_db@wildcard_table
PREHOOK: query: DROP DATABASE col_test_db CASCADE
PREHOOK: type: DROPDATABASE
PREHOOK: Input: database:col_test_db
PREHOOK: Output: col_test_db@wildcard_table
PREHOOK: Output: database:col_test_db
POSTHOOK: query: DROP DATABASE col_test_db CASCADE
POSTHOOK: type: DROPDATABASE
POSTHOOK: Input: database:col_test_db
POSTHOOK: Output: col_test_db@wildcard_table
POSTHOOK: Output: database:col_test_db