hadoop配置单元数据加载

lymnna71  于 2021-06-26  发布在  Hive
关注(0)|答案(1)|浏览(333)

我有下面格式的json数据,我只需要将“text”字段插入到配置单元的表中。

[
  {
    "fullname": "Jia Khan",   
    "id": "832576802904240129",
    "likes": "1",
    "replies": "0",
    "retweets": "0",
    "text": "This is gonna be an intense showdown only if the weather showed some mercy. @PeshawarZalmi #AbKhelJamayGa #PZvQG #HarDilZalmi #HBLPSL",
    "timestamp": "2017-02-17T13:05:52",
    "user": "iamJiaKhan"
  }
]
wn9m85ua

wn9m85ua1#

首先,您可以为所有数据字段创建一个临时表,然后您可以通过从临时表中仅选择一个必需字段来创建最终表。

相关问题