wangbowen1024 opened a new issue, #15371:
URL: https://github.com/apache/dolphinscheduler/issues/15371

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### What happened
   
   i get error like this when run `null value check` DQ task :
   > [INFO] 2023-12-27 01:16:31.722 +0800 -  -> 
     Exception in thread "main" org.apache.spark.sql.AnalysisException: cannot 
resolve '`AS`' given input columns: [null_count.nulls]; line 1 pos 165;
     'Project [0 AS rule_type#18, (null_check) AS rule_name#19, 0 AS 
process_definition_id#20, 81 AS process_instance_id#21, 247 AS 
task_instance_id#22, nulls#15L AS statistics_value#23L, 'AS AS 
comparison_value#24, 1 AS comparison_type#25, 0 AS check_type#26, 1 AS 
threshold#27, 4 AS operator#28, 0 AS failure_strategy#29, 
hdfs://BIGDATA/user/test/data_quality_error_data/0_81_null-presto AS 
error_output_path#30, 2023-12-27 01:16:16 AS create_time#31, 2023-12-27 
01:16:16 AS update_time#32]
     +- SubqueryAlias null_count
        +- Aggregate [count(1) AS nulls#15L]
           +- SubqueryAlias null_items
              +- Project [province#0, city#1, county#2]
                 +- Filter (isnull(city#1) || (city#1 = ))
                    +- SubqueryAlias test_region
                       +- Project [province#0, city#1, county#2]
                          +- SubqueryAlias region
                             +- HiveTableRelation `test`.`region`, 
org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [province#0, city#1, 
county#2]
    
   it just like SQL Generation error, `'AS AS comparison_value#24`
   
   i find other issue,Maybe it's a similar problem in [Bug] [data quality] sql 
error when adding data_quality task #15249
   
   ### What you expected to happen
   
   none
   
   ### How to reproduce
   
   everytime
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   3.2.x
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to