Nested subquery in phoenix

fberksoz — Wed, 22 Mar 2017 00:42:49 GMT

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,

Re: Nested subquery in phoenix

namaheshwari — Wed, 22 Mar 2017 03:27:06 GMT

@Faruk Berksoz -

Below query should work fine:

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

question Re: Nested subquery in phoenix in Support Questions

Nested subquery in phoenix

Re: Nested subquery in phoenix