大数据配置单元查询

2izufjch 于 2021-05-29 发布在 Hadoop

关注(0)|答案(1)|浏览(317)

我有以下数据

Policy_Name  IssueYear   ExpiryYear
A            2001        2003
B            2003        2006

我需要如下输出：

Policy_Name ActiveYear
A           2001
A           2002
A           2003
B           2003
B           2004 
B           2005
B           2006

hadoop Hive hiveql apache

来源：https://stackoverflow.com/questions/42886585/big-data-hive-query

1条答案

按热度按时间

mwg9r5ms1#

select  t.Policy_Name 
       ,t.IssueYear + pe.i  as ActiveYear

from    mytable t
        lateral view posexplode (split (space (ExpiryYear - IssueYear),' ')) pe as i,x
;

+---------------+------------+
| t.policy_name | activeyear |
+---------------+------------+
| A             |       2001 |
| A             |       2002 |
| A             |       2003 |
| B             |       2003 |
| B             |       2004 |
| B             |       2005 |
| B             |       2006 |
+---------------+------------+

赞(0）回复(0）举报 2021-05-29

我来回答

大数据配置单元查询

1条答案

相关问题

热门标签

最新问答