---- Replied Message ----
| From | lpc_encode<lpc_enc...@aliyun.com> |
| Date | 7/14/2022 13:54 |
| To | user@hive.apache.org<user@hive.apache.org> |
| Cc | user@hive.apache.org<user@hive.apache.org> |
| Subject | Re: hive table with special character for column name |
---- Replied Message ----
| From | second_comet.yahoo.com via user<user@hive.apache.org> |
| Date | 7/14/2022 13:50 |
| To | User<user@hive.apache.org> |
| Subject | hive table with special character for column name |
I able to create hive table with special character ^ in column name . example column name : column^test . but when I do select * from the table, i get below error
Error: java.io.IOException: java.lang.IllegalArgumentException: Error: name expected at the position 40 of 'struct<$timestamp:string,company:string,^level:string,title:string,totalyearlycompensation:int,!location:string,????_yearsofexperience:double,yearsatcompany:double,tag:string,basesalary:int,stockgrantvalue:double,bonus:double,gender:string,otherdetails:string,cityid:int,dmaid:string,rownumber:int,masters_degree:int,bachelors_degree:int,doctorate_degree:int,highschool:int,some_college:int,race_asian:int,race_white:int,race_two_or_more:int,race_black:int,race_hispanic:int,race:string,education:string>' but '^' is found. (state=,code=0)
Why hive server allow to create table with special character ^ for column name but cannot query using a select statement ?
Thank you,
Comet
