I have created a table in phoenix through this sql using sqlline and inserted the data -
create table test2(pk integer primary key,col1 integer,col2 double,col3 varchar);
upsert into test2 values (1, 1, 1.1, 'qwerty');
upsert into test2 values (2, 2, 1.23, 'test');
I can see the data when i do a select on test2 in sqlline . But when i try to read data of test2 table from Squirrel i get null for col1, col2 and col3. Please see attached photo.
When the table is created through psl.py and we perform bulk loading operation we can see the data in Squirrel.
Please help me understand why i am unable to see the data when table is created through sqlline.