sql-tests/inputs/describe-query.sql

0001 -- Test tables
0002 CREATE table  desc_temp1 (key int COMMENT 'column_comment', val string) USING PARQUET;
0003 CREATE table  desc_temp2 (key int, val string) USING PARQUET;
0004
0005 -- Simple Describe query
0006 DESC SELECT key, key + 1 as plusone FROM desc_temp1;
0007 DESC QUERY SELECT * FROM desc_temp2;
0008 DESC SELECT key, COUNT(*) as count FROM desc_temp1 group by key;
0009 DESC SELECT 10.00D as col1;
0010 DESC QUERY SELECT key FROM desc_temp1 UNION ALL select CAST(1 AS DOUBLE);
0011 DESC QUERY VALUES(1.00D, 'hello') as tab1(col1, col2);
0012 DESC QUERY FROM desc_temp1 a SELECT *;
0013 DESC WITH s AS (SELECT 'hello' as col1) SELECT * FROM s;
0014 DESCRIBE QUERY WITH s AS (SELECT * from desc_temp1) SELECT * FROM s;
0015 DESCRIBE SELECT * FROM (FROM desc_temp2 select * select *);
0016
0017 -- Error cases.
0018 DESCRIBE INSERT INTO desc_temp1 values (1, 'val1');
0019 DESCRIBE INSERT INTO desc_temp1 SELECT * FROM desc_temp2;
0020 DESCRIBE
0021    FROM desc_temp1 a
0022      insert into desc_temp1 select *
0023      insert into desc_temp2 select *;
0024
0025 -- Explain
0026 EXPLAIN DESC QUERY SELECT * FROM desc_temp2 WHERE key > 0;
0027 EXPLAIN EXTENDED DESC WITH s AS (SELECT 'hello' as col1) SELECT * FROM s;
0028
0029 -- cleanup
0030 DROP TABLE desc_temp1;
0031 DROP TABLE desc_temp2;