sql在查询语句中直接用value创建临时表

Hive CTE, can I query values as table? – sql server

with    tbl_test_values as
        (
            select  inline
                    (
                        array
                        (
                            struct ('Number','1','One')
                           ,struct ('Number','5','Five')
                           ,struct ('Letter','A','First Letter')
                           ,struct ('Human','Bob','Dude')
                        )
                    ) as (Name, Value, Descript)
        )

select * from tbl_test_values
;

with    tbl_test_values as
        (
            select  stack
                    (
                        4
                       ,'Number' ,'1'   ,'One'
                       ,'Number' ,'5'   ,'Five'
                       ,'Letter' ,'A'   ,'First Letter'
                       ,'Human'  ,'Bob' ,'Dude'
                    ) as (Name, Value, Descript)
        )

select * from tbl_test_values
;