>
> All these pain we need to take because the column names have special
>> character like " ' _- ( ) '' ¬ " etc.
>>
>
Hmm. I tried:

cqlsh:test> create table quoted_col_name ( pk int primary key, "'_-()""¬"
int);

cqlsh:test> select * from quoted_col_name;

 *pk* | *'_-()"¬*

----+---------
(0 rows)


So one can quote at least some chars, including all the ones you mentioned.

However, cqlsh does have a bug:

cqlsh:test> DESCRIBE TABLE quoted_col_name

*'ascii' codec can't decode byte 0xc2 in position 72: ordinal not in
range(128)*

Anyway, perhaps you can avoid the "pain" you referenced above.

ml

Reply via email to