@Shu Thank you for the update.
1) I have created two tables, one for datatype int and one for string.
create table test001_int(ida int);
create table test001_string(ida string);
2) When I try to insert " ? " to string table I am able to insert successfully
insert into test001_string values('?');
select * from test001_string;
+---------------------+--+
| test001_string.ida |
+---------------------+--+
| ? |
+---------------------+--+
3) When I try to insert " ? " to int table I am getting below Error
insert into test001_int values(?);
Error: Error while compiling statement: FAILED: ParseException line 1:31 cannot recognize input near '?' ')' '<EOF>' in value row constructor (state=42000,code=40000)
insert into test001_int values('?');
select * from test001_int;
+------------------+--+
| test001_int.ida |
+------------------+--+
| NULL |
+------------------+--+
insert into test001_int values('\u003F');
select * from test001_int;
+------------------+--+
| test001_int.ida |
+------------------+--+
| NULL |
| NULL |
+------------------+--+
So my question is how can I insert " ? " in column with INT datatype (NOT string) and for select query I am getting NULL is there any different way to display " ? " in select query.
... View more
