argodb认证及建表语句

先认证

kinit -kt xxx.keytab xxx@TDH

连接

beeline -u "jdbc:transwarp2://192.xxx.xx.xxx:10000" -n test -p xxx

可以重复insert 相同的数，会根据id自动更新

CREATE TABLE  `cs`.`e1`( `id` INT  ,
`double_test` DOUBLE,
`decimal_test` DECIMAL(38,10),
`tinyint_test` TINYINT,
`boolean_test` BOOLEAN,
`char_test` STRING,
`bigint_test` BIGINT,
`float_test` FLOAT,
`smallint_test` SMALLINT,
`time_test` TIME,
`fdatetime_test` TIMESTAMP(6),
`int_test` INT,
`varchar_test` STRING,
`date_test` DATE) 
CLUSTERED BY (id) 
INTO 2 BUCKETS 
STORED AS HOLODESK
TBLPROPERTIES ('holodesk.rowkey'='id') ;

 可以重复insert 相同的数，不会根据id自动更新

CREATE TABLE  `cs`.`e3`( `id` INT  ,
`double_test` DOUBLE,
`decimal_test` DECIMAL(38,10),
`tinyint_test` TINYINT,
`boolean_test` BOOLEAN,
`char_test` STRING,
`bigint_test` BIGINT,
`float_test` FLOAT,
`smallint_test` SMALLINT,
`time_test` TIME,
`fdatetime_test` TIMESTAMP(6),
`int_test` INT,
`varchar_test` STRING,
`date_test` DATE) STORED AS HOLODESK;

不能重复insert id相同的数

CREATE TABLE  `cs`.`e2`( `id` INT primary key ,
`double_test` DOUBLE,
`decimal_test` DECIMAL(38,10),
`tinyint_test` TINYINT,
`boolean_test` BOOLEAN,
`char_test` STRING,
`bigint_test` BIGINT,
`float_test` FLOAT,
`smallint_test` SMALLINT,
`time_test` TIME,
`fdatetime_test` TIMESTAMP(6),
`int_test` INT,
`varchar_test` STRING,
`date_test` DATE) 
CLUSTERED BY (id) 
INTO 2 BUCKETS 
STORED AS HOLODESK
TBLPROPERTIES ('holodesk.rowkey'='id') ;