redis数据库建表的方法:
在DMS for Data Lake Analytics中创建表dla_person_csv,代码如下:
CREATE EXTERNAL TABLE dla_person_csv (id int,name varchar,age int) TBLPROPERTIES (COLUMN_MAPPING = 'id,0;name,1;age,2',TABLE_MAPPING = 'world_',format = 'csv');
CREATE EXTERNAL TABLE dla_person_csv (
id int,
name varchar,
age int
) TBLPROPERTIES (
COLUMN_MAPPING = 'id,0;name,1;age,2',
TABLE_MAPPING = 'world_',
format = 'csv'
);