sql-tests/inputs/csv-functions.sql

0001 -- from_csv
0002 select from_csv('1, 3.14', 'a INT, f FLOAT');
0003 select from_csv('26/08/2015', 'time Timestamp', map('timestampFormat', 'dd/MM/yyyy'));
0004 -- Check if errors handled
0005 select from_csv('1', 1);
0006 select from_csv('1', 'a InvalidType');
0007 select from_csv('1', 'a INT', named_struct('mode', 'PERMISSIVE'));
0008 select from_csv('1', 'a INT', map('mode', 1));
0009 select from_csv();
0010 -- infer schema of json literal
0011 select from_csv('1,abc', schema_of_csv('1,abc'));
0012 select schema_of_csv('1|abc', map('delimiter', '|'));
0013 select schema_of_csv(null);
0014 CREATE TEMPORARY VIEW csvTable(csvField, a) AS SELECT * FROM VALUES ('1,abc', 'a');
0015 SELECT schema_of_csv(csvField) FROM csvTable;
0016 -- Clean up
0017 DROP VIEW IF EXISTS csvTable;
0018 -- to_csv
0019 select to_csv(named_struct('a', 1, 'b', 2));
0020 select to_csv(named_struct('time', to_timestamp('2015-08-26', 'yyyy-MM-dd')), map('timestampFormat', 'dd/MM/yyyy'));
0021 -- Check if errors handled
0022 select to_csv(named_struct('a', 1, 'b', 2), named_struct('mode', 'PERMISSIVE'));
0023 select to_csv(named_struct('a', 1, 'b', 2), map('mode', 1));