hive从hdfs文件系统里面读取数据

    xiaoxiao2021-03-25  119

    CREATE EXTERNAL TABLE `old_user_info`( `user_id` bigint ,   `PlatformId` string ,   `SelfChannel` string ,   `ChannelToken` string ,   `lv` bigint ,   `gm_stone` bigint ,   `charge_stone` bigint ,   `create_time` bigint ,   `last_act_time` bigint ) ROW FORMAT DELIMITED    FIELDS TERMINATED BY ','  STORED AS INPUTFORMAT    'org.apache.hadoop.mapred.TextInputFormat'  OUTPUTFORMAT    'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION   'hdfs://127.0.0.1:9000/user/input/' TBLPROPERTIES (   'COLUMN_STATS_ACCURATE'='false',    'numFiles'='0',    'numRows'='-1',    'rawDataSize'='-1',    'totalSize'='0',    'transient_lastDdlTime'='1439809315')
    转载请注明原文地址: https://ju.6miu.com/read-12348.html

    最新回复(0)