JSON解析SERDE阵列结构问题

Question

我的JSON对象：

{ 
    "_total": 4, 
    "values": [ 
     { 
      "total-follower-count": 63911, 
      "organic-follower-count": 6000, 
      "paid-follower-count": 3911, 
      "time": 1399334400000 
     }, 
     { 
      "total-follower-count": 64023, 
      "organic-follower-count": 6000, 
      "paid-follower-count": 4023, 
      "time": 1399420800000 
     }, 
     { 
      "total-follower-count": 64023, 
      "organic-follower-count": 6000, 
      "paid-follower-count": 4023, 
      "time": 1399507200000 
     }, 
     { 
      "total-follower-count": 64048, 
      "organic-follower-count": 6000, 
      "paid-follower-count": 4048, 
      "time": 1399593600000 
     } 
    ] 
} 

在AWS雅典娜，我创建了一个表像之下。我不能访问像“Total_Follower_count”这样的数组值。能否请你帮忙。谢谢

Answer 1

你需要扁平你的阵列，并执行你的选择。

在这里明显的例子记载，

http://docs.aws.amazon.com/athena/latest/ug/flattening-arrays.html

希望它能帮助。