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
