Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Nested subquery in phoenix

avatar
Contributor

Hi all,

what is wrong ? Env. Hdp 2.4

> phoenix 
CREATE TABLE TB.TABLE1
(
  COL1         VARCHAR(3)                   NOT NULL
 ,COL2         VARCHAR(20)
 ,CONSTRAINT pk PRIMARY KEY (COL1)  
)	









SELECT T.* FROM (
	  SELECT * FROM TB.TABLE1
	) T


SQL Error [1001] [42I01]: ERROR 1001 (42I01): Undefined column family. familyName=T.null
  org.apache.phoenix.schema.ColumnFamilyNotFoundException: ERROR 1001 (42I01): Undefined column family. familyName=T.null
	

Thanks,

1 ACCEPTED SOLUTION

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login