when use beeline cli or pyhive to do select * from table , it will return error
like i mentioned. The screenshot you are using GUI to access database server
directly right?
On Thursday, July 14, 2022 at 02:43:44 PM GMT+8, lpc_encode
<lpc_enc...@aliyun.com> wrote:
#yiv5242789865 font{line-height:1.6;}#yiv5242789865 ul, #yiv5242789865
ol{padding-left:20px;list-style-position:inside;}
| | lpc_encode |
| lpc_enc...@aliyun.com |
---- 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
