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; | |
-- Integers | |
select nvl(t, true) from over1k limit 5; |