就 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)
......
Select Language