问题描述:阿兹卡班调度hive任务
NoViableAltException(9@[423:1: atomExpression : ( constant | ( intervalExpression )=> intervalExpression | castExpression | extractExpression | floorExpression | caseExpression | whenExpression | ( subQueryExpression )=> ( subQueryExpression ) -> ^( TOK_SUBQUERY_EXPR TOK_SUBQUERY_OP subQueryExpression ) | ( functionName LPAREN )=> function | tableOrColumn | expressionsInParenthesis[true, false] );])
06-01-2022 03:48:17 GMT hive_ads INFO - at org.apache.hadoop.hive.ql.parse.HiveParser_IdentifiersParser$DFA36.specialStateTransition(HiveParser_IdentifiersParser.java:34559)
代码如下:
hive -e "use test;insert into table zf_merchants_subject_credit_grade
select
regexp_replace(reflect(''java.util.UUID'', ''randomUUID''), ''-'', '''') as id,
concat(tba1.id,date_format(add_months(current_date(),-1),'yyyyMM')) as credit_id,
from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:mm:ss') as create_time,
concat('admin') as create_by,
from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:mm:ss') as update_time,
concat('admin') as update_by,
concat('0') as del_flag,
tba2.credit_type as credit_type,
tba2.indicator as indicator,
tba2.grade as credit_grade,
tba2.credit_standard as credit_standard,
tba2.total_num as credit_total,
tba2.indicator_english
from tmp as tba1
join zf_merchants_subject_credit_rule as tba2 on tba1.type = tba2.type_name
where tba1.grade >= tba2.min and tba1.grade < tba2.max;"
解决方法:
将双引号改成单引号
regexp_replace(reflect('java.util.UUID', 'randomUUID'), '-', '') as id