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'
);