set hive.cbo.enable=false;

-- check cluster/distribute/partitionBy
SELECT * FROM SRC x where x.key = 20 CLUSTER BY (key,value) ;

SELECT * FROM SRC x where x.key = 20 CLUSTER BY ((key),value) ;

SELECT * FROM SRC x where x.key = 20 CLUSTER BY (key,(value)) ;

SELECT * FROM SRC x where x.key = 20 CLUSTER BY ((key),(value)) ;

SELECT * FROM SRC x where x.key = 20 CLUSTER BY ((key),(((value))));

-- HIVE-6950
SELECT tab1.key,
       tab1.value,
       SUM(1)
FROM src as tab1
GROUP BY tab1.key,
         tab1.value
GROUPING SETS ((tab1.key, tab1.value));

SELECT key,
       src.value,
       SUM(1)
FROM src
GROUP BY key,
         src.value
GROUPING SETS ((key, src.value));

explain extended select int(1.2) from src limit 1;
select int(1.2) from src limit 1;
select bigint(1.34) from src limit 1;
select binary('1') from src limit 1;
select boolean(1) from src limit 1;
select date('1') from src limit 2;
select double(1) from src limit 1;
select float(1) from src limit 1;
select smallint(0.9) from src limit 1;
select timestamp('1') from src limit 2;

explain extended desc default.src key;

desc default.src key;