今天学了hive
和数据库的语句
查看hive版本:
mysql> select * from VERSION;查看有哪些表:
mysql> select * from TBLS \G;
查看表对应的hdfs目录的metedata:
mysql> select * from SDS \G;
查看某个表的partitions:
mysql> select * from PARTITIONS where TBL_ID=1 \G;
查看某个表的列:
mysql> select * from COLUMNS_V2;
查看某个表的partition:
mysql> select * from PARTITION_KEYS;