clickhouse查询语法--from

from

SQL是一种面向集合的编程语言，from决定了程序从哪里读取数据
1）表中查询数据
2）子查询中查询数据
3）表的数中查询数据 select * from numbers(3);

file

file(path,format,structure)  //数据文件必须在指定的目录下

例如
select * from file('/var/lib/clickhouse/demo.csv','CSV','id Int8,name String,age UInt8')

number

select number from numbers(5);
┌─number─┐
│      0 │
│      1 │
│      2 │
│      3 │
│      4 │
└────────┘

select * from numbers(2,5);
┌─number─┐
│      2 │
│      3 │
│      4 │
│      5 │
│      6 │
└────────┘

select toDate('2020-01-01')+number as d from numbers(5);
┌──────────d─┐
│ 2020-01-01 │
│ 2020-01-02 │
│ 2020-01-03 │
│ 2020-01-04 │
│ 2020-01-05 │
└────────────┘

mysql

mysql('host:port','database','table','user','password');

hdfs

select * from hdfs('hdfs://spark-140:8020/clickhouse/user.txt','CSV','id UInt8,name String,gender String,age UInt8')