查询bucketized表

jaxagkaj  于 2021-06-02  发布在  Hadoop
关注(0)|答案(0)|浏览(202)

我创建了一个bucketized表,如下所示

drop table if exists bi_st.st_usr_member_active_day_test;
CREATE TABLE `bi_st.st_usr_member_active_day_test`(
`cal_dt_from` string,
  `cal_dt_to` string,
  `memberid` string, 
  `vipcode` string, 
  `vipleavel` string, 
  `cityid` string, 
  `cityname` string, 
  `groupid` int, 
  `groupname` string, 
  `storeid` int,
  `storename` string, 
  `sectionid` int, 
  `sectionname` string, 
  `promotionid` string, 
  `promotionname` string, 
  `moduleid` string, 
  `modulename` string, 
  `activeness_today` string, 
  `new_vip_class` string
  )
  clustered by (storeid) into 2 buckets 
  row format delimited fields terminated by '\t'
  stored as orc TBLPROPERTIES('transactional'='true');

然后在里面插入了一些数据,然后我做了 select * from bi_st.st_usr_member_active_day_test where storeid = 193; ,失败并给出数组索引越界错误。有人能解释一下吗?谢谢

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题