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.

Select query on phoenix table

Select query on phoenix table

New Contributor

Hi All i'm new to phoenix let me know how to get the all the records from a table. when i run the query(select * from table) on top of phoenix table it was giving the very first row not entire records.

Thanks Advance,

Viswanatha Reddy

2 REPLIES 2

Re: Select query on phoenix table

Can you clarify what you mean by "it was giving the very first row not entire records", please? Maybe you can provide some example commands and output from what you ran so we can try to give you a better answer.

Highlighted

Re: Select query on phoenix table

Rising Star

"select * from <tablename>" should give all records.

try "select count(*) from <tablename>" to confirm total records in table

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