[ 
https://issues.apache.org/jira/browse/HIVE-2155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13033173#comment-13033173
 ] 

jirapos...@reviews.apache.org commented on HIVE-2155:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/731/#review669
-----------------------------------------------------------



ql/src/test/results/clientnegative/create_view_failure3.q.out
<https://reviews.apache.org/r/731/#comment1333>

    This is an example where an existing error should have been using the new 
"Error encountered...".  You can either take care of these now, or open a 
followup for that.



ql/src/test/results/clientnegative/ddltime.q.out
<https://reviews.apache.org/r/731/#comment1332>

    Need a period before "Error encountered...".  That's true in general;.
    



ql/src/test/results/clientnegative/groupby_key.q.out
<https://reviews.apache.org/r/731/#comment1331>

    This is kinda ugly...


- John


On 2011-05-12 23:44:48, Syed Albiz wrote:
bq.  
bq.  -----------------------------------------------------------
bq.  This is an automatically generated e-mail. To reply, visit:
bq.  https://reviews.apache.org/r/731/
bq.  -----------------------------------------------------------
bq.  
bq.  (Updated 2011-05-12 23:44:48)
bq.  
bq.  
bq.  Review request for hive and John Sichi.
bq.  
bq.  
bq.  Summary
bq.  -------
bq.  
bq.  Attaches line/column number to the vast majority of SemanticExceptions 
thrown. In addition, the context strings for the error messages relating to 
UNION ALLs and GROUP BY keys have been changed to provide more meaningful 
context.
bq.  
bq.  
bq.  This addresses bug HIVE-2155.
bq.      https://issues.apache.org/jira/browse/HIVE-2155
bq.  
bq.  
bq.  Diffs
bq.  -----
bq.  
bq.    common/src/java/org/apache/hadoop/hive/conf/HiveConf.java dc96a1f 
bq.    ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java 
2fe37b6 
bq.    ql/src/java/org/apache/hadoop/hive/ql/parse/ErrorMsg.java 4ddf5b9 
bq.    ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 
9cb407c 
bq.    ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java 
bca37fd 
bq.    ql/src/test/queries/clientnegative/union3.q PRE-CREATION 
bq.    ql/src/test/results/clientnegative/analyze_view.q.out ef76106 
bq.    ql/src/test/results/clientnegative/clusterbydistributeby.q.out 4c1ebfb 
bq.    ql/src/test/results/clientnegative/clusterbysortby.q.out f76d4a7 
bq.    ql/src/test/results/clientnegative/clustern3.q.out da71016 
bq.    ql/src/test/results/clientnegative/clustern4.q.out 1519e48 
bq.    ql/src/test/results/clientnegative/create_view_failure3.q.out 70e365a 
bq.    ql/src/test/results/clientnegative/ddltime.q.out 11d00c3 
bq.    ql/src/test/results/clientnegative/drop_partition_failure.q.out 1a0ac10 
bq.    ql/src/test/results/clientnegative/dyn_part2.q.out cc0cd3c 
bq.    ql/src/test/results/clientnegative/fileformat_void_input.q.out 5a7a05a 
bq.    ql/src/test/results/clientnegative/groupby_key.q.out c6218a4 
bq.    ql/src/test/results/clientnegative/input1.q.out 73f1657 
bq.    ql/src/test/results/clientnegative/input2.q.out 0c460a6 
bq.    ql/src/test/results/clientnegative/invalidate_view1.q.out 9f61228 
bq.    ql/src/test/results/clientnegative/joinneg.q.out d85d508 
bq.    ql/src/test/results/clientnegative/line_terminator.q.out b672bd8 
bq.    ql/src/test/results/clientnegative/load_wrong_noof_part.q.out 4d8c8d8 
bq.    ql/src/test/results/clientnegative/nopart_insert.q.out 42bca76 
bq.    ql/src/test/results/clientnegative/notable_alias3.q.out d48d5e1 
bq.    ql/src/test/results/clientnegative/orderbysortby.q.out 73b83a4 
bq.    ql/src/test/results/clientnegative/regex_col_1.q.out 7547858 
bq.    ql/src/test/results/clientnegative/regex_col_2.q.out f570010 
bq.    ql/src/test/results/clientnegative/regex_col_groupby.q.out 8497718 
bq.    ql/src/test/results/clientnegative/semijoin1.q.out 739931f 
bq.    ql/src/test/results/clientnegative/semijoin2.q.out 2b418de 
bq.    ql/src/test/results/clientnegative/semijoin3.q.out a803b50 
bq.    ql/src/test/results/clientnegative/semijoin4.q.out 86a834b 
bq.    ql/src/test/results/clientnegative/split_sample_out_of_range.q.out 
0761955 
bq.    ql/src/test/results/clientnegative/split_sample_wrong_format.q.out 
19b1417 
bq.    ql/src/test/results/clientnegative/strict_orderby.q.out 2d3ba6b 
bq.    ql/src/test/results/clientnegative/subq_insert.q.out 8c3ce79 
bq.    ql/src/test/results/clientnegative/udf_array_contains_wrong1.q.out 
d6b98b4 
bq.    ql/src/test/results/clientnegative/udf_array_contains_wrong2.q.out 
7b8dca6 
bq.    ql/src/test/results/clientnegative/udf_case_type_wrong.q.out 75b9638 
bq.    ql/src/test/results/clientnegative/udf_case_type_wrong2.q.out 126fa4e 
bq.    ql/src/test/results/clientnegative/udf_case_type_wrong3.q.out fd62771 
bq.    ql/src/test/results/clientnegative/udf_coalesce.q.out a5279f5 
bq.    ql/src/test/results/clientnegative/udf_elt_wrong_args_len.q.out 22a085a 
bq.    ql/src/test/results/clientnegative/udf_elt_wrong_type.q.out fc83f23 
bq.    ql/src/test/results/clientnegative/udf_field_wrong_args_len.q.out 
3bf97d9 
bq.    ql/src/test/results/clientnegative/udf_field_wrong_type.q.out 2a2e944 
bq.    ql/src/test/results/clientnegative/udf_if_not_bool.q.out a3c8902 
bq.    ql/src/test/results/clientnegative/udf_if_wrong_args_len.q.out 89b23c8 
bq.    ql/src/test/results/clientnegative/udf_in.q.out 50a6b98 
bq.    ql/src/test/results/clientnegative/udf_instr_wrong_args_len.q.out 
7f66db7 
bq.    ql/src/test/results/clientnegative/udf_instr_wrong_type.q.out 89d8542 
bq.    ql/src/test/results/clientnegative/udf_locate_wrong_args_len.q.out 
46613e8 
bq.    ql/src/test/results/clientnegative/udf_locate_wrong_type.q.out 42cc4b6 
bq.    ql/src/test/results/clientnegative/udf_size_wrong_args_len.q.out b05731e 
bq.    ql/src/test/results/clientnegative/udf_size_wrong_type.q.out 0c91c8f 
bq.    ql/src/test/results/clientnegative/udf_when_type_wrong.q.out bec3725 
bq.    ql/src/test/results/clientnegative/udf_when_type_wrong2.q.out 5b06467 
bq.    ql/src/test/results/clientnegative/udf_when_type_wrong3.q.out 6974dd7 
bq.    ql/src/test/results/clientnegative/udtf_not_supported1.q.out cc5f23b 
bq.    ql/src/test/results/clientnegative/udtf_not_supported2.q.out c8987ea 
bq.    ql/src/test/results/clientnegative/union.q.out 333230d 
bq.    ql/src/test/results/clientnegative/union2.q.out 1e6c782 
bq.    ql/src/test/results/clientnegative/union3.q.out PRE-CREATION 
bq.    ql/src/test/results/compiler/errors/ambiguous_table_col.q.out 1641ead 
bq.    ql/src/test/results/compiler/errors/duplicate_alias.q.out 1429744 
bq.    ql/src/test/results/compiler/errors/insert_wrong_number_columns.q.out 
7efe359 
bq.    ql/src/test/results/compiler/errors/invalid_dot.q.out e63be5f 
bq.    ql/src/test/results/compiler/errors/invalid_function_param2.q.out 
f1f41a1 
bq.    ql/src/test/results/compiler/errors/invalid_index.q.out 77dc0c0 
bq.    ql/src/test/results/compiler/errors/invalid_list_index.q.out 3714b68 
bq.    ql/src/test/results/compiler/errors/invalid_list_index2.q.out c64b248 
bq.    ql/src/test/results/compiler/errors/invalid_map_index.q.out e241bc6 
bq.    ql/src/test/results/compiler/errors/invalid_map_index2.q.out 1c8d660 
bq.    ql/src/test/results/compiler/errors/nonkey_groupby.q.out 21a9f46 
bq.    ql/src/test/results/compiler/errors/unknown_column1.q.out 4d89065 
bq.    ql/src/test/results/compiler/errors/unknown_column2.q.out 43f31db 
bq.    ql/src/test/results/compiler/errors/unknown_column3.q.out d8ee8d0 
bq.    ql/src/test/results/compiler/errors/unknown_column4.q.out 24d8c87 
bq.    ql/src/test/results/compiler/errors/unknown_column5.q.out d15e993 
bq.    ql/src/test/results/compiler/errors/unknown_column6.q.out aac42d1 
bq.    ql/src/test/results/compiler/errors/unknown_function1.q.out 5180f38 
bq.    ql/src/test/results/compiler/errors/unknown_function2.q.out dcb97bc 
bq.    ql/src/test/results/compiler/errors/unknown_function3.q.out dcb97bc 
bq.    ql/src/test/results/compiler/errors/unknown_function4.q.out 5180f38 
bq.    ql/src/test/results/compiler/errors/unknown_table1.q.out ff92e4e 
bq.    ql/src/test/results/compiler/errors/unknown_table2.q.out 54185e4 
bq.    ql/src/test/results/compiler/errors/wrong_distinct1.q.out 74bc6e6 
bq.  
bq.  Diff: https://reviews.apache.org/r/731/diff
bq.  
bq.  
bq.  Testing
bq.  -------
bq.  
bq.  Regenerated testcase expected output for 
TestNegativeCliDriver/TestParseNegative/TestNegativeContribCliDriver
bq.  
bq.  
bq.  Thanks,
bq.  
bq.  Syed
bq.  
bq.



> Improve error messages emitted during semantic analysis
> -------------------------------------------------------
>
>                 Key: HIVE-2155
>                 URL: https://issues.apache.org/jira/browse/HIVE-2155
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Syed S. Albiz
>            Assignee: Syed S. Albiz
>         Attachments: HIVE-2155.1.patch, HIVE-2155.2.patch, HIVE-2155.3.patch
>
>
> Follow-up to HIVE-1731.
> A number of issues raised in HIVE-1731 were caused by SemanticAnalyzer not 
> reporting errors correctly.
> Specifically, the following issues need to be addressed:
> - Line numbers are not always provided and sometimes emitted as (0:-1), which 
> is useless
> - Insufficient or unclear context strings are provided
> Specific issues described in HIVE-1731:
> FAILED: Error in semantic analysis: Schema of both sides of union should 
> match: destinationid:_col1 _col2
> * No line/col numbers, context strings provide internal aliases instead of 
> actual column names
> FAILED: Error in semantic analysis: line 0:-1 Both Left and Right Aliases 
> Encountered in Join time
> * Incorrect line/col number info, no context strings to describe the aliases 
> encountered
> FAILED: Error in semantic analysis: AS clause has an invalid number of aliases
> * No line/col numbers, not context string to show the aliases encountered
> FAILED: Error in semantic analysis: line 1:94 Expression Not In Group By Key a
> * testcase: SELECT a.id, VAR(a.cnt) FROM mytable a
> * Context string is unhelpful, needs to provide the actual expression, not 
> just the table reference

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to