[feat] replace into table on (x) select * from @stage/file does not support NDJSON format

[hantmac]

Summary

reproduce step

1. create stage and generate ndjson file

CREATE STAGE sjhstage;

copy into @sjhstage FROM 
(
    SELECT * 
    FROM 
    (
        VALUES 
        (1, 'Chengdu', 80),
        (3, 'Chongqing', 90),
        (6, 'Hangzhou', 92),
        (9, 'Hong Kong', 88)
    )
)
FILE_FORMAT = (TYPE = NDJSON);

2. create target table

CREATE TABLE sample
(
    id      INT,
    city    VARCHAR,
    score   INT,
    country VARCHAR DEFAULT 'China'
);

3. replace into target table

REPLACE INTO sample
    (id, city, score) 
ON
    (Id)
SELECT * from @sjhstage/data_4e264479-077b-44ff-ae68-cec7a974e882_0000_00000000.ndjson;

or

REPLACE INTO sample
    (id, city, score) 
ON
    (Id)
SELECT * from @sjhstage (FILE_FORMAT => 'ndjson');

We will get the following error:

Query ID: 46d42da4-193d-43ce-9c5e-a0681ad2020a
1065=>
select * from file only support Parquet format

How about supporting ndjson and csv file in relace into x select * from stage file ?

[wubx]

Query stage with json not support select * , Please read: https://docs.databend.com/guides/load-data/transform/querying-ndjson

[youngsofun]

@hantmac this issue in fact not a bug, but a feature request 😄