使用公司的即席查询系统,做sql语句查询,但是一直报错,数据源名称为adhoc-hive,应该是hive数据库吧,而且订单清单的表单显示的sql语句,跟我写的结构完全一样啊,不知道原因为何,请坛友指导😭
测试的简单的查询语句
select
订单号,
客户姓名,
商品代码,
商品类别代码,
cast(公司订单份额 as string) as 份额
from "01 宽表/02 订单清单"
报错显示
Encountered " "AS" "as "" at line 11, column 17. Was expecting one of: "," ... ")" ... "." ... "+" ... "-" ... "*" ... "||" ... "/" ... "**" ... "." ...
用的啥数据库 有string这个数据类型?