例: 集約されない結果を返す - Advanced SQL Engine - Teradata Database

次のAVROの例では、結果は集約されません。例えば、1つのテーブルの各行は1つのDATASETデータ型のインスタンスになります。

SELECT * FROM DATASET_PUBLISH
(
	ON (SELECT * FROM employeeTable) 
	RETURNS (data DATASET STORAGE FORMAT AVRO)
	USING DO_AGGREGATE('N')
) AS avroFiles;

data
7B226E616D65223A22656D706C6F7965655461626C65222C2274797065223A227265636F7264222C226669656C6473223A5B7B226E616D65223A22656D704944222C2274797065223A22696E74227D2C7B226E616D65223A22656D704E616D65222C2274797065223A22737472696E67227D2C7B226E616D65223A22656D7044657074222C2274797065223A22737472696E67227D5D7D00021847656F72676520536D697468144163636F756E74696E67

7B226E616D65223A22656D706C6F7965655461626C65222C2274797065223A227265636F7264222C226669656C6473223A5B7B226E616D65223A22656D704944222C2274797065223A22696E74227D2C7B226E616D65223A22656D704E616D65222C2274797065223A22737472696E67227D2C7B226E616D65223A22656D7044657074222C2274797065223A22737472696E67227D5D7D00041C5061756C696E65204B72616D6572044852

7B226E616D65223A22656D706C6F7965655461626C65222C2274797065223A227265636F7264222C226669656C6473223A5B7B226E616D65223A22656D704944222C2274797065223A22696E74227D2C7B226E616D65223A22656D704E616D65222C2274797065223A22737472696E67227D2C7B226E616D65223A22656D7044657074222C2274797065223A22737472696E67227D5D7D00061853746576656E204D617A7A6F16456E67696E656572696E67

結果は、CSVの例では集約されません。

SELECT * FROM DATASET_PUBLISH
(
	ON (SELECT * FROM employeeTable) 
	RETURNS (data DATASET STORAGE FORMAT CSV)
	USING DO_AGGREGATE('N')
) AS csvFiles;