> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Limitations

<a id="sql-limitations" />

*Kinetica* has some limitations with current features and has removed support
for some legacy features.

## Feature Limitations

* Correlated subqueries have the following limitations:

  * They cannot reference grouping columns in the parent query
  * They cannot reference tables beyond the immediate outer query; i.e., a
    table cannot be referenced in a correlated subquery that is two or more
    levels of nesting deeper than it is
  * They cannot contain disjunctive conditions
  * They cannot be part of an `OUTER JOIN ON` clause condition

## Legacy Features

* Store-only columns are no longer supported
* Disk-optimized columns are no longer supported

## Not Yet Supported SQL

* Windowing Features

  * Frame Exclusion (`EXCLUDE`)

* Ranking Functions

  * `PERCENTILE_CONT`
  * `PERCENTILE_DISC`