The CREATE TABLE miniapp_game_pay_detail (
Ftime BIGINT COMMENT 'date',
The tag BIGINT COMMENT '1 for prepaid phone, 2 for consumption,
Uin STRING COMMENT 'user ID',
Fuin STRING COMMENT 'calculation when the users use this'
Appid STRING COMMENT 'appid,
Ftran_amt BIGINT COMMENT 'amount, unit the collectibles, 10 collectibles=1 yuan')
The COMMENT 'top-up consumption water;


The CREATE EXTERNAL TABLE midapp_t_dw_nrt141424 (
Ftime BIGINT COMMENT 'date',
Appid STRING COMMENT 'appid,
App_name STRING COMMENT 'app name')
The COMMENT 'information sheet'


The CREATE TABLE miniapp_dau_detail_3 (
Ftime BIGINT COMMENT 'date',
Uin BIGINT COMMENT 'user ID',
Appid STRING COMMENT 'appid,
Refer the STRING the COMMENT 'channels')
The COMMENT 'day visitors'