hadoop配置单元数据加载

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

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

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

wn9m85ua1#

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

相关问题