| create table over1k( | |
| t tinyint, | |
| si smallint, | |
| i int, | |
| b bigint, | |
| f float, | |
| d double, | |
| bo boolean, | |
| s string, | |
| ts timestamp, | |
| `dec` decimal(4,2), | |
| bin binary) | |
| row format delimited | |
| fields terminated by '|'; | |
| load data local inpath '../../data/files/over1k' into table over1k; | |
| -- Pass non-strings for the first and third arguments to test argument conversion | |
| -- Negative tests: LIST, MAP, STRUCT, UNION | |
| -- Integers | |
| select lpad(array(1,2,3), 4, ' ') from over1k limit 5; |