gistfile1.txt

-- -*- sql-product: drill -*- --
VALUES 1;

EXPLAIN PLAN FOR VALUES 1;

!help

SHOW DATABASES;

SHOW TABLES IN INFORMATION_SCHEMA;
SELECT * FROM INFORMATION_SCHEMA.`TABLES`;


SHOW TABLES IN sys;

SELECT * from sys.options;

SELECT * from sys.drillbits;

VALUES NOW();

SHOW DATABASES;


SELECT * FROM sys.boot WHERE name LIKE '%dir%';


SHOW TABLES IN dfs;

SHOW DATABASES;

USE dfs;

SHOW FILES;

SHOW FILES in dfs.`/home/kim/compile/apache-drill-1.6.0/sample-data/`;

SELECT * FROM dfs.`/home/kim/compile/apache-drill-1.6.0/sample-data/nation.parquet`;

SELECT *
FROM dfs.`/home/kim/compile/apache-drill-1.6.0/sample-data/nation.parquet`;


SELECT *
FROM dfs.`/home/kim/compile/apache-drill-1.6.0/sample-data/nation.parquet`
WHERE N_NATIONKEY = 12;

SELECT *
FROM dfs.`/home/kim/compile/apache-drill-1.6.0/sample-data/regionsSF`;

SELECT *
FROM dfs.`/home/kim/compile/apache-drill-1.6.0/sample-data/regionsMF`;

SELECT *
FROM dfs.`/home/kim/compile/apache-drill-1.6.0/sample-data/region.parquet`;