PREHOOK: query: -- SORT_QUERY_RESULTS USE default PREHOOK: type: SWITCHDATABASE PREHOOK: Input: database:default POSTHOOK: query: -- SORT_QUERY_RESULTS USE default POSTHOOK: type: SWITCHDATABASE POSTHOOK: Input: database:default PREHOOK: query: CREATE TABLE dest1(bytes1 BINARY, bytes2 BINARY, string STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(bytes1 BINARY, bytes2 BINARY, string STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@dest1 PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT CAST(key AS BINARY), CAST(value AS BINARY), value ORDER BY value LIMIT 100 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@dest1 POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT CAST(key AS BINARY), CAST(value AS BINARY), value ORDER BY value LIMIT 100 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@dest1 POSTHOOK: Lineage: dest1.bytes1 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: dest1.bytes2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: dest1.string SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: --Add in a null row for good measure INSERT INTO TABLE dest1 SELECT NULL, NULL, NULL FROM dest1 LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@dest1 PREHOOK: Output: default@dest1 POSTHOOK: query: --Add in a null row for good measure INSERT INTO TABLE dest1 SELECT NULL, NULL, NULL FROM dest1 LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@dest1 POSTHOOK: Output: default@dest1 POSTHOOK: Lineage: dest1.bytes1 EXPRESSION [] POSTHOOK: Lineage: dest1.bytes2 EXPRESSION [] POSTHOOK: Lineage: dest1.string SIMPLE [] PREHOOK: query: -- this query tests all the udfs provided to work with binary types SELECT bytes1, bytes2, string, LENGTH(bytes1), CONCAT(bytes1, bytes2), SUBSTR(bytes2, 1, 4), SUBSTR(bytes2, 3), SUBSTR(bytes2, -4, 3), HEX(bytes1), UNHEX(HEX(bytes1)), BASE64(bytes1), UNBASE64(BASE64(bytes1)), HEX(ENCODE(string, 'US-ASCII')), DECODE(ENCODE(string, 'US-ASCII'), 'US-ASCII') FROM dest1 PREHOOK: type: QUERY PREHOOK: Input: default@dest1 #### A masked pattern was here #### POSTHOOK: query: -- this query tests all the udfs provided to work with binary types SELECT bytes1, bytes2, string, LENGTH(bytes1), CONCAT(bytes1, bytes2), SUBSTR(bytes2, 1, 4), SUBSTR(bytes2, 3), SUBSTR(bytes2, -4, 3), HEX(bytes1), UNHEX(HEX(bytes1)), BASE64(bytes1), UNBASE64(BASE64(bytes1)), HEX(ENCODE(string, 'US-ASCII')), DECODE(ENCODE(string, 'US-ASCII'), 'US-ASCII') FROM dest1 POSTHOOK: type: QUERY POSTHOOK: Input: default@dest1 #### A masked pattern was here #### 0 val_0 val_0 1 0val_0 val_ l_0 al_ 30 0 MA== 0 76616C5F30 val_0 0 val_0 val_0 1 0val_0 val_ l_0 al_ 30 0 MA== 0 76616C5F30 val_0 0 val_0 val_0 1 0val_0 val_ l_0 al_ 30 0 MA== 0 76616C5F30 val_0 10 val_10 val_10 2 10val_10 val_ l_10 l_1 3130 10 MTA= 10 76616C5F3130 val_10 100 val_100 val_100 3 100val_100 val_ l_100 _10 313030 100 MTAw 100 76616C5F313030 val_100 100 val_100 val_100 3 100val_100 val_ l_100 _10 313030 100 MTAw 100 76616C5F313030 val_100 103 val_103 val_103 3 103val_103 val_ l_103 _10 313033 103 MTAz 103 76616C5F313033 val_103 103 val_103 val_103 3 103val_103 val_ l_103 _10 313033 103 MTAz 103 76616C5F313033 val_103 104 val_104 val_104 3 104val_104 val_ l_104 _10 313034 104 MTA0 104 76616C5F313034 val_104 104 val_104 val_104 3 104val_104 val_ l_104 _10 313034 104 MTA0 104 76616C5F313034 val_104 105 val_105 val_105 3 105val_105 val_ l_105 _10 313035 105 MTA1 105 76616C5F313035 val_105 11 val_11 val_11 2 11val_11 val_ l_11 l_1 3131 11 MTE= 11 76616C5F3131 val_11 111 val_111 val_111 3 111val_111 val_ l_111 _11 313131 111 MTEx 111 76616C5F313131 val_111 113 val_113 val_113 3 113val_113 val_ l_113 _11 313133 113 MTEz 113 76616C5F313133 val_113 113 val_113 val_113 3 113val_113 val_ l_113 _11 313133 113 MTEz 113 76616C5F313133 val_113 114 val_114 val_114 3 114val_114 val_ l_114 _11 313134 114 MTE0 114 76616C5F313134 val_114 116 val_116 val_116 3 116val_116 val_ l_116 _11 313136 116 MTE2 116 76616C5F313136 val_116 118 val_118 val_118 3 118val_118 val_ l_118 _11 313138 118 MTE4 118 76616C5F313138 val_118 118 val_118 val_118 3 118val_118 val_ l_118 _11 313138 118 MTE4 118 76616C5F313138 val_118 119 val_119 val_119 3 119val_119 val_ l_119 _11 313139 119 MTE5 119 76616C5F313139 val_119 119 val_119 val_119 3 119val_119 val_ l_119 _11 313139 119 MTE5 119 76616C5F313139 val_119 119 val_119 val_119 3 119val_119 val_ l_119 _11 313139 119 MTE5 119 76616C5F313139 val_119 12 val_12 val_12 2 12val_12 val_ l_12 l_1 3132 12 MTI= 12 76616C5F3132 val_12 12 val_12 val_12 2 12val_12 val_ l_12 l_1 3132 12 MTI= 12 76616C5F3132 val_12 120 val_120 val_120 3 120val_120 val_ l_120 _12 313230 120 MTIw 120 76616C5F313230 val_120 120 val_120 val_120 3 120val_120 val_ l_120 _12 313230 120 MTIw 120 76616C5F313230 val_120 125 val_125 val_125 3 125val_125 val_ l_125 _12 313235 125 MTI1 125 76616C5F313235 val_125 125 val_125 val_125 3 125val_125 val_ l_125 _12 313235 125 MTI1 125 76616C5F313235 val_125 126 val_126 val_126 3 126val_126 val_ l_126 _12 313236 126 MTI2 126 76616C5F313236 val_126 128 val_128 val_128 3 128val_128 val_ l_128 _12 313238 128 MTI4 128 76616C5F313238 val_128 128 val_128 val_128 3 128val_128 val_ l_128 _12 313238 128 MTI4 128 76616C5F313238 val_128 128 val_128 val_128 3 128val_128 val_ l_128 _12 313238 128 MTI4 128 76616C5F313238 val_128 129 val_129 val_129 3 129val_129 val_ l_129 _12 313239 129 MTI5 129 76616C5F313239 val_129 129 val_129 val_129 3 129val_129 val_ l_129 _12 313239 129 MTI5 129 76616C5F313239 val_129 131 val_131 val_131 3 131val_131 val_ l_131 _13 313331 131 MTMx 131 76616C5F313331 val_131 133 val_133 val_133 3 133val_133 val_ l_133 _13 313333 133 MTMz 133 76616C5F313333 val_133 134 val_134 val_134 3 134val_134 val_ l_134 _13 313334 134 MTM0 134 76616C5F313334 val_134 134 val_134 val_134 3 134val_134 val_ l_134 _13 313334 134 MTM0 134 76616C5F313334 val_134 136 val_136 val_136 3 136val_136 val_ l_136 _13 313336 136 MTM2 136 76616C5F313336 val_136 137 val_137 val_137 3 137val_137 val_ l_137 _13 313337 137 MTM3 137 76616C5F313337 val_137 137 val_137 val_137 3 137val_137 val_ l_137 _13 313337 137 MTM3 137 76616C5F313337 val_137 138 val_138 val_138 3 138val_138 val_ l_138 _13 313338 138 MTM4 138 76616C5F313338 val_138 138 val_138 val_138 3 138val_138 val_ l_138 _13 313338 138 MTM4 138 76616C5F313338 val_138 138 val_138 val_138 3 138val_138 val_ l_138 _13 313338 138 MTM4 138 76616C5F313338 val_138 138 val_138 val_138 3 138val_138 val_ l_138 _13 313338 138 MTM4 138 76616C5F313338 val_138 143 val_143 val_143 3 143val_143 val_ l_143 _14 313433 143 MTQz 143 76616C5F313433 val_143 145 val_145 val_145 3 145val_145 val_ l_145 _14 313435 145 MTQ1 145 76616C5F313435 val_145 146 val_146 val_146 3 146val_146 val_ l_146 _14 313436 146 MTQ2 146 76616C5F313436 val_146 146 val_146 val_146 3 146val_146 val_ l_146 _14 313436 146 MTQ2 146 76616C5F313436 val_146 149 val_149 val_149 3 149val_149 val_ l_149 _14 313439 149 MTQ5 149 76616C5F313439 val_149 149 val_149 val_149 3 149val_149 val_ l_149 _14 313439 149 MTQ5 149 76616C5F313439 val_149 15 val_15 val_15 2 15val_15 val_ l_15 l_1 3135 15 MTU= 15 76616C5F3135 val_15 15 val_15 val_15 2 15val_15 val_ l_15 l_1 3135 15 MTU= 15 76616C5F3135 val_15 150 val_150 val_150 3 150val_150 val_ l_150 _15 313530 150 MTUw 150 76616C5F313530 val_150 152 val_152 val_152 3 152val_152 val_ l_152 _15 313532 152 MTUy 152 76616C5F313532 val_152 152 val_152 val_152 3 152val_152 val_ l_152 _15 313532 152 MTUy 152 76616C5F313532 val_152 153 val_153 val_153 3 153val_153 val_ l_153 _15 313533 153 MTUz 153 76616C5F313533 val_153 155 val_155 val_155 3 155val_155 val_ l_155 _15 313535 155 MTU1 155 76616C5F313535 val_155 156 val_156 val_156 3 156val_156 val_ l_156 _15 313536 156 MTU2 156 76616C5F313536 val_156 157 val_157 val_157 3 157val_157 val_ l_157 _15 313537 157 MTU3 157 76616C5F313537 val_157 158 val_158 val_158 3 158val_158 val_ l_158 _15 313538 158 MTU4 158 76616C5F313538 val_158 160 val_160 val_160 3 160val_160 val_ l_160 _16 313630 160 MTYw 160 76616C5F313630 val_160 162 val_162 val_162 3 162val_162 val_ l_162 _16 313632 162 MTYy 162 76616C5F313632 val_162 163 val_163 val_163 3 163val_163 val_ l_163 _16 313633 163 MTYz 163 76616C5F313633 val_163 164 val_164 val_164 3 164val_164 val_ l_164 _16 313634 164 MTY0 164 76616C5F313634 val_164 164 val_164 val_164 3 164val_164 val_ l_164 _16 313634 164 MTY0 164 76616C5F313634 val_164 165 val_165 val_165 3 165val_165 val_ l_165 _16 313635 165 MTY1 165 76616C5F313635 val_165 165 val_165 val_165 3 165val_165 val_ l_165 _16 313635 165 MTY1 165 76616C5F313635 val_165 166 val_166 val_166 3 166val_166 val_ l_166 _16 313636 166 MTY2 166 76616C5F313636 val_166 167 val_167 val_167 3 167val_167 val_ l_167 _16 313637 167 MTY3 167 76616C5F313637 val_167 167 val_167 val_167 3 167val_167 val_ l_167 _16 313637 167 MTY3 167 76616C5F313637 val_167 167 val_167 val_167 3 167val_167 val_ l_167 _16 313637 167 MTY3 167 76616C5F313637 val_167 168 val_168 val_168 3 168val_168 val_ l_168 _16 313638 168 MTY4 168 76616C5F313638 val_168 169 val_169 val_169 3 169val_169 val_ l_169 _16 313639 169 MTY5 169 76616C5F313639 val_169 169 val_169 val_169 3 169val_169 val_ l_169 _16 313639 169 MTY5 169 76616C5F313639 val_169 169 val_169 val_169 3 169val_169 val_ l_169 _16 313639 169 MTY5 169 76616C5F313639 val_169 169 val_169 val_169 3 169val_169 val_ l_169 _16 313639 169 MTY5 169 76616C5F313639 val_169 17 val_17 val_17 2 17val_17 val_ l_17 l_1 3137 17 MTc= 17 76616C5F3137 val_17 170 val_170 val_170 3 170val_170 val_ l_170 _17 313730 170 MTcw 170 76616C5F313730 val_170 172 val_172 val_172 3 172val_172 val_ l_172 _17 313732 172 MTcy 172 76616C5F313732 val_172 172 val_172 val_172 3 172val_172 val_ l_172 _17 313732 172 MTcy 172 76616C5F313732 val_172 174 val_174 val_174 3 174val_174 val_ l_174 _17 313734 174 MTc0 174 76616C5F313734 val_174 174 val_174 val_174 3 174val_174 val_ l_174 _17 313734 174 MTc0 174 76616C5F313734 val_174 175 val_175 val_175 3 175val_175 val_ l_175 _17 313735 175 MTc1 175 76616C5F313735 val_175 175 val_175 val_175 3 175val_175 val_ l_175 _17 313735 175 MTc1 175 76616C5F313735 val_175 176 val_176 val_176 3 176val_176 val_ l_176 _17 313736 176 MTc2 176 76616C5F313736 val_176 176 val_176 val_176 3 176val_176 val_ l_176 _17 313736 176 MTc2 176 76616C5F313736 val_176 177 val_177 val_177 3 177val_177 val_ l_177 _17 313737 177 MTc3 177 76616C5F313737 val_177 178 val_178 val_178 3 178val_178 val_ l_178 _17 313738 178 MTc4 178 76616C5F313738 val_178 179 val_179 val_179 3 179val_179 val_ l_179 _17 313739 179 MTc5 179 76616C5F313739 val_179 179 val_179 val_179 3 179val_179 val_ l_179 _17 313739 179 MTc5 179 76616C5F313739 val_179 18 val_18 val_18 2 18val_18 val_ l_18 l_1 3138 18 MTg= 18 76616C5F3138 val_18 18 val_18 val_18 2 18val_18 val_ l_18 l_1 3138 18 MTg= 18 76616C5F3138 val_18 180 val_180 val_180 3 180val_180 val_ l_180 _18 313830 180 MTgw 180 76616C5F313830 val_180 181 val_181 val_181 3 181val_181 val_ l_181 _18 313831 181 MTgx 181 76616C5F313831 val_181 183 val_183 val_183 3 183val_183 val_ l_183 _18 313833 183 MTgz 183 76616C5F313833 val_183 186 val_186 val_186 3 186val_186 val_ l_186 _18 313836 186 MTg2 186 76616C5F313836 val_186 187 val_187 val_187 3 187val_187 val_ l_187 _18 313837 187 MTg3 187 76616C5F313837 val_187 187 val_187 val_187 3 187val_187 val_ l_187 _18 313837 187 MTg3 187 76616C5F313837 val_187 187 val_187 val_187 3 187val_187 val_ l_187 _18 313837 187 MTg3 187 76616C5F313837 val_187 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL