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

Primary Key issue in Phoenix


Primary Key issue in Phoenix

New Contributor

I have a table of 8 columns where 'employee' is a primary key in that table. When I am trying to retrieve the rows using primary key, I am not getting any results even there is data in the table. My query is "select * from employees_table where employee = '1028'. The table has a record of 1028. when I am trying to retrieve using primary key , I am getting empty results. Why I am getting empty results? It works when I tried to use other columns but not working with the primary key. Please explain me the reason. Please help me.


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