ql/src/test/queries/clientpositive/split.q

DROP TABLE tmp_jo_tab_test;
CREATE table tmp_jo_tab_test (message_line STRING)
STORED AS TEXTFILE;

LOAD DATA LOCAL INPATH '../../data/files/input.txt'
OVERWRITE INTO TABLE tmp_jo_tab_test;

select size(split(message_line, '\t')) from tmp_jo_tab_test;