Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

i am not able to query a table created in Phoenix from Squirrel.

Highlighted

i am not able to query a table created in Phoenix from Squirrel.

New Contributor

Hi,

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.

Don't have an account?
Coming from Hortonworks? Activate your account here