Showing All Flags in the Catalog Table
SQream uses the sqream_catalog.parameters catalog table for showing all flags, providing the scope (default, cluster and session), description, default value and actual value.
The following is the correct syntax for a catalog table query:
SELECT * FROM sqream_catalog.parameters;
The following is an example of a catalog table query:
externalTableBlobEstimate, 100, 100, default,
ascii, ascii, default, Changes the expected encoding for Varchar columns
useCrcForTextJoinKeys, true, true, default,
hiveStyleImplicitStringCasts, false, false, default,