1、impala/spark常见的命令汇总
常见命令 | impala | spark sql |
---|---|---|
create语句 | CREATE TABLE IF NOT EXISTS my_db.student (name STRING, age INT, contact INT ); | CREATE TABLE t2_part(user_id BIGINT, firstname STRING, lastname STRING)PARTITIONED BY(ds STRING); |
insert语句 | Insert into(overwrite) table_name values (value1, value2, value2); | Insert into(overwrite) table_name values (value1, value2, value2); |
select语句 | SELECT column1, column2, columnN from table_name; | SELECT column1, column2, columnN from table_name; |
describe语句 | Describe table_name; | Describe table_name; |
alter语句 | ALTER TABLE my_db.customer |