首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >在apache超级集中可视化apache数据时出错

在apache超级集中可视化apache数据时出错
EN

Stack Overflow用户
提问于 2018-03-12 10:24:59
回答 1查看 266关注 0票数 1

我试图使用官方博客指南设置的apache查看apache数据,但是在查询结果表后单击“可视化”按钮时遇到了以下错误。我已将kylinpy升级为最新版本。我知道正确的sql应该是"WHERE MONTH_BEG_DT >= '1918-03-12‘和MONTH_BEG_DT <= '2018-03-12'",但它是由超级集auto生成的。

代码语言:javascript
复制
Caused by: java.lang.NumberFormatException: For input string: "12 00:00:00"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:580)
    at java.lang.Integer.parseInt(Integer.java:615)
    at org.apache.calcite.avatica.util.DateTimeUtils.dateStringToUnixDate(DateTimeUtils.java:637)
    at Baz$6$1.<clinit>(Unknown Source)
    ... 99 more
2018-03-12 18:13:12,606 INFO  [Query eb988c1e-5f6c-4275-a9b8-1946f5976020-60] service.QueryService:328 : 
==========================[QUERY]===============================
Query Id: eb988c1e-5f6c-4275-a9b8-1946f5976020
SQL: SELECT META_CATEG_NAME AS META_CATEG_NAME,
       sum(CNT) AS sum__CNT
FROM
  (select YEAR_BEG_DT,
          MONTH_BEG_DT,
          WEEK_BEG_DT,
          META_CATEG_NAME,
          CATEG_LVL2_NAME,
          CATEG_LVL3_NAME,
          OPS_REGION,
          NAME as BUYER_COUNTRY_NAME,
          sum(PRICE) as GMV,
          sum(ACCOUNT_BUYER_LEVEL) ACCOUNT_BUYER_LEVEL,
          count(*) as CNT
   from KYLIN_SALES
   join KYLIN_CAL_DT on CAL_DT = PART_DT
   join KYLIN_CATEGORY_GROUPINGS on SITE_ID = LSTG_SITE_ID
   and KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID = KYLIN_SALES.LEAF_CATEG_ID
   join KYLIN_ACCOUNT on ACCOUNT_ID = BUYER_ID
   join KYLIN_COUNTRY on ACCOUNT_COUNTRY = COUNTRY
   group by YEAR_BEG_DT,
            MONTH_BEG_DT,
            WEEK_BEG_DT,
            META_CATEG_NAME,
            CATEG_LVL2_NAME,
            CATEG_LVL3_NAME,
            OPS_REGION,
            NAME) AS expr_qry
WHERE MONTH_BEG_DT >= '1918-03-12 00:00:00'
  AND MONTH_BEG_DT <= '2018-03-12 18:13:11'
GROUP BY META_CATEG_NAME
ORDER BY sum__CNT DESC
LIMIT 5000
User: ADMIN
Success: true
Duration: 1.313
Project: learn_kylin
Realization Names: [CUBE[name=kylin_sales_cube]]
Cuboid Ids: [23715]
Total scan count: 9946
Total scan bytes: 556263
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==========================[QUERY]===============================
EN

回答 1

Stack Overflow用户

发布于 2018-03-15 11:36:18

请检查超集中的列(维度)类型,确保类型是数据,然后确保kylinpy版本高于1.0.9。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/49232911

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档