Query hint for SQL queries to serialize complex types (ARRAY, MAP, STRUCT) as CLOBs (their string representation) for routed JDBC/ODBC queries rather than as serialized blobs to display better in external tools.
Query hint for SQL queries to serialize complex types (ARRAY, MAP, STRUCT) as CLOBs (their string representation) for routed JDBC/ODBC queries rather than as serialized blobs to display better in external tools.
Possible values are 'true/1' or 'false/0'
Example:
SELECT * FROM t1 --+ complexTypeAsClob(1)
SQL query hints as interpreted by the SnappyData SQL parser. The format mirrors closely the format used by Hive,Oracle query hints with a comment followed immediately by a '+' and then "key(value)" for the hint. Example:
SELECT * /*+ hint(value) */FROM t1