Hi, > hive is case insensitive
I know some db are case insensitive for column names and table names, but they usually allow users specifically define a case sensitive name using double quotation "", e.g., create table "tableName" ( "iD" int...). At least, I know Cassandra supports that. I am not sure whether Hive supports that, you can have a try. By the way, if Hive really does not support capital string as a name, we have to notify users to pay attention to that and do not create time series with capital strings if they want to use hive in the future. (I think this is a common solution when some systems integrate with other function-limited systems..) Best, ----------------------------------- Xiangdong Huang School of Software, Tsinghua University 黄向东 清华大学 软件学院 Tian Jiang <jt2594...@163.com> 于2019年10月18日周五 下午3:05写道： > Hi, > > > Case insensitive databases are common and I think this does ease the > burden of designing the grammar. > How about having a talk with @康愈圆? > > > Best, > > > Tian Jiang > > > On 10/18/2019 14:49，田原<tian...@mails.tsinghua.edu.cn> wrote： > Hi, > > > When I implement the hive-connector, I found that hive is case > insensitive. And the column names got from the properties are all lower > case. When I use the column name as sensorId to collect data from tsfile, > if the sensorId has uppercase letters, I won't get anything but null, > because our IoTDB is case sensitive. > > > And, I can't figure out a good solution. Anyone has ideas about it? Or > maybe we can make our IoTDB to be case insensitive. > > > Best, > -------------- > Yuan Tian > School of Software, Tsinghua University > > 田原 > 清华大学 软件学院
