1. []
    3.     : ./sqlline.py node-master2goch:2181
    5. []
    7.     # 列出metadata信息
    8.     : !dbinfo
    10.   # 创建表
    11.   : create table if not exists sinoxx.student(id integer primary key,name varchar(20));
    13.   # 当前库存在的表
    14.   : !tables
    16.   // phoenix中的表信息都存在SYSTEM.CATALOG表中，也可以通过下面的sql语句查看系统的表信息
    18.   : select * from SYSTEM.CATALOG;
    19.   // 如果不加双引号, 会自动将小写转为大写
    20.   // phoenix表名区分大小写
    22.   # 删除表
    23.   : drop table sinoxx.alarm;
    25.   # 查看表结构
    26.   !describe "METRIC_AGGREGATE"
    28.     : select * from sinoxx.alarm_record where alarm_type_id in (40,33) and create_date > TO_TIMESTAMP('2020-03-20 04:44:03') and create_date < TO_TIMESTAMP('2020-03-20 04:45:03')  order by create_date desc limit 20;
    30. []
    32.     : select * from sinoxx.alarm_record where vehicle_id in ('V103346','V102136') and  alarm_type_id in (40,33) and create_date > TO_TIMESTAMP('2020-03-20 04:44:03') and create_date < TO_TIMESTAMP('2020-03-20 04:45:03')  order by create_date desc limit 20
    35. []
    37.     # 查询总数
    38.     : SELECT count(1) FROM sinoxx.alarm_record
    40.   select count(1) from sinoxx.alarm_record
    41.       where vehicle_id in ('V103346','V102136')
    42.         and  alarm_type_id in (40,33)
    43.         and create_date > TO_TIMESTAMP('2020-03-22 08:00:00')
    44.         and create_date < TO_TIMESTAMP('2020-03-22 09:00:00')
    45.          order by row_key
    47.     : SELECT * FROM sinoxx.alarm_record
    48.   where vehicle_id in ('V103346','V102136')
    49.         and  alarm_type_id in (40,33)
    50.         and create_date > TO_TIMESTAMP('2020-03-22 08:00:00')
    51.         and create_date < TO_TIMESTAMP('2020-03-22 09:00:00')
    52.   order by create_date
    53.   LIMIT 5 OFFSET 1;
    55.   // SELECT * FROM TEST LIMIT pageSize OFFSET startRowNo;
    57.     : select * from sinoxx.alarm_record
    58.   where row_key >=
    59.   ( select max(row_key) from
    60.     (select row_key from sinoxx.alarm_record
    61.       where vehicle_id in ('V103346','V102136')
    62.         and  alarm_type_id in (40,33)
    63.         and create_date > TO_TIMESTAMP('2020-03-22 08:00:00')
    64.         and create_date < TO_TIMESTAMP('2020-03-22 09:00:00')
    65.         order by row_key  limit  1
    66.       )
    67.    ) order by row_key  limit 5;
    69.     //
    70.    select * from t where sqCol>= 
    71.    (select  max(sqCol)  from 
    72.     (select sqCol  from t where ...  order by sqCol  limit  startRowNo))
    73.     order by sqCol  limit pageSize;