就 22 个不多不少。
只要超过 22 个就报错,把字段减少到 22 个以下就没问题。
报错如图
详细信息:
com.alipay.dwsap.common.exception.AlisisRuntimeException: 6 AE0510000002:Database access error:JDBC 查询出错(a2dc16b1-2a38-4705-9287-4a4534a494ee):6 AE0570010010:fail to execute task, 6 6 AE0510000002:Database access error:JDBC 查询出错(a2dc16b1-2a38-4705-9287-4a4534a494ee):StatementCallback; uncategorized SQLException for SQL [select T1310145776.注册手机号
as t1310145776dimension1, date_format(T1310145776.下单时间
, '%Y%m%d') as t1310145776dimension2dateregion, T1310145776.订单号
as t1310145776dimension3, T1310145776.用户 id
as t1310145776dimension4, T1310145776.渠道订单号
as t1310145776dimension5, T1310145776.一级品类
as t1310145776dimension6, T1310145776.商品名称
as t1310145776dimension7, T1310145776.规格
as t1310145776dimension8, T1310145776.支付编号
as t1310145776dimension9, T1310145776.收货地址
as t1310145776dimension10, T1310145776.支付方式
as t1310145776dimension11, T1310145776.付款方式
as t1310145776dimension12, T1310145776.支付交易号
as t1310145776dimension13, T1310145776.是否取消
as t1310145776dimension14, T1310145776.订单状态
as t1310145776dimension15, T1310145776.供应商
as t1310145776dimension16, T1310145776.是否为电话下单
as t1310145776dimension17, T1310145776.渠道
as t1310145776dimension18, T
com.alibaba.yunbi.core.query.dal.JdbcCommonForwarder.query(JdbcCommonForwarder.java:129)
com.alipay.dwsap.core.service.query.olap.executor.OlapSqlQueryExecutorImpl.query(OlapSqlQueryExecutorImpl.java:73)
com.alipay.dwsap.core.service.query.OlapQueryEngine.executeInternal2(OlapQueryEngine.java:323)
......
1
knightdf 2017-09-08 16:29:46 +08:00
23333, 可能是他们用的 scala 的 tuple 限制了 22 个字段
|
2
liprais 2017-09-08 16:30:26 +08:00
scala 写的吧,简直笑翻
|
5
mengxy 2017-09-12 17:28:18 +08:00
@Cabana
亲爱的 QuickBI 用户您好,您的问题已经排查到,报错关键信息如下: error code [1038]; Out of sort memory, consider increasing server sort buffer size; nested exception is java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size。 您可以尝试调大 mysql 服务端的 sort_buffer_size 参数,默认为 3M,尝试调大到 10M 后再试试。 您在使用 QuickBI 过程中遇到的任何问题,都可以通过 QuickBI 工单系统( https://selfservice.console.aliyun.com/ticket/category/quickbi/today )提问,我们会及时准确的解答您的问题。QuickBI 官网: http://bi.aliyun.com 。 @liprais @knightdf 另外说明一下哈,QuickBI 是 Java 开发的啊,scala 的锅我们不背,2333333。 |