Kinetica has some limitations for any columns marked as store-only and string columns lacking a charN attribute.
Unlimited-Width Strings
String columns with no charN attribute are stored in whole on disk and in hashed form in memory. Because the strings are only available for processing as hashes, only equality-based operations can be applied to them.
Partially Applicable Operations
- Scalar Column Functions
- Null Functions (except ZEROIFNULL )
- Conditional Functions (equality-based)
- Aggregate Column Functions
- COUNT
- COUNT DISTINCT
- WHERE (predicate condition must be equality-based)
- JOIN (join condition must be equality-based)
Inapplicable Operations
- Subqueries requiring a temporary view to be created
- GROUP BY
- UNION
- INTERSECT
- EXCEPT
- CREATE TABLE ... AS
Store-Only Columns
Columns marked store-only are only stored on disk, not in memory. Because they are not available for processing, only data extraction operations can be applied to them.
Inapplicable Operations
- Scalar or Aggregate Column Functions
- Subqueries requiring a temporary view to be created
- WHERE
- GROUP BY
- JOIN
- UNION
- INTERSECT
- EXCEPT
- CREATE TABLE ... AS
Not Yet Supported SQL
- Windowing Features
- Frame Exclusion (EXCLUDE)
- Ranking Functions
- PERCENTILE_DISC
- PERCENTILE_CONT
- Writing CSV files