| |
| <!DOCTYPE html> |
| <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]--> |
| <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]--> |
| <!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]--> |
| <!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]--> |
| <head> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| <meta name="viewport" content="width=device-width, initial-scale=1.0"> |
| |
| <title>Error Conditions - Spark 3.5.0 Documentation</title> |
| |
| |
| |
| |
| |
| <link rel="stylesheet" href="css/bootstrap.min.css"> |
| <link rel="preconnect" href="https://fonts.googleapis.com"> |
| <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> |
| <link href="https://fonts.googleapis.com/css2?family=DM+Sans:ital,wght@0,400;0,500;0,700;1,400;1,500;1,700&Courier+Prime:wght@400;700&display=swap" rel="stylesheet"> |
| <link href="css/custom.css" rel="stylesheet"> |
| <script src="js/vendor/modernizr-2.6.1-respond-1.1.0.min.js"></script> |
| |
| <link rel="stylesheet" href="css/pygments-default.css"> |
| <link rel="stylesheet" href="css/docsearch.min.css" /> |
| <link rel="stylesheet" href="css/docsearch.css"> |
| |
| <!-- Matomo --> |
| <script type="text/javascript"> |
| var _paq = window._paq = window._paq || []; |
| /* tracker methods like "setCustomDimension" should be called before "trackPageView" */ |
| _paq.push(["disableCookies"]); |
| _paq.push(['trackPageView']); |
| _paq.push(['enableLinkTracking']); |
| (function() { |
| var u="https://analytics.apache.org/"; |
| _paq.push(['setTrackerUrl', u+'matomo.php']); |
| _paq.push(['setSiteId', '40']); |
| var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0]; |
| g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s); |
| })(); |
| </script> |
| <!-- End Matomo Code --> |
| </head> |
| <body class="global"> |
| <!--[if lt IE 7]> |
| <p class="chromeframe">You are using an outdated browser. <a href="https://browsehappy.com/">Upgrade your browser today</a> or <a href="http://www.google.com/chromeframe/?redirect=true">install Google Chrome Frame</a> to better experience this site.</p> |
| <![endif]--> |
| |
| <!-- This code is taken from http://twitter.github.com/bootstrap/examples/hero.html --> |
| |
| <nav class="navbar navbar-expand-lg navbar-dark p-0 px-4 fixed-top" style="background: #1d6890;" id="topbar"> |
| <div class="navbar-brand"><a href="index.html"> |
| <img src="img/spark-logo-rev.svg" width="141" height="72"/></a><span class="version">3.5.0</span> |
| </div> |
| <button class="navbar-toggler" type="button" data-toggle="collapse" |
| data-target="#navbarCollapse" aria-controls="navbarCollapse" |
| aria-expanded="false" aria-label="Toggle navigation"> |
| <span class="navbar-toggler-icon"></span> |
| </button> |
| <div class="collapse navbar-collapse" id="navbarCollapse"> |
| <ul class="navbar-nav me-auto"> |
| <li class="nav-item"><a href="index.html" class="nav-link">Overview</a></li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarQuickStart" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Programming Guides</a> |
| <div class="dropdown-menu" aria-labelledby="navbarQuickStart"> |
| <a class="dropdown-item" href="quick-start.html">Quick Start</a> |
| <a class="dropdown-item" href="rdd-programming-guide.html">RDDs, Accumulators, Broadcasts Vars</a> |
| <a class="dropdown-item" href="sql-programming-guide.html">SQL, DataFrames, and Datasets</a> |
| <a class="dropdown-item" href="structured-streaming-programming-guide.html">Structured Streaming</a> |
| <a class="dropdown-item" href="streaming-programming-guide.html">Spark Streaming (DStreams)</a> |
| <a class="dropdown-item" href="ml-guide.html">MLlib (Machine Learning)</a> |
| <a class="dropdown-item" href="graphx-programming-guide.html">GraphX (Graph Processing)</a> |
| <a class="dropdown-item" href="sparkr.html">SparkR (R on Spark)</a> |
| <a class="dropdown-item" href="api/python/getting_started/index.html">PySpark (Python on Spark)</a> |
| </div> |
| </li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarAPIDocs" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">API Docs</a> |
| <div class="dropdown-menu" aria-labelledby="navbarAPIDocs"> |
| <a class="dropdown-item" href="api/scala/org/apache/spark/index.html">Scala</a> |
| <a class="dropdown-item" href="api/java/index.html">Java</a> |
| <a class="dropdown-item" href="api/python/index.html">Python</a> |
| <a class="dropdown-item" href="api/R/index.html">R</a> |
| <a class="dropdown-item" href="api/sql/index.html">SQL, Built-in Functions</a> |
| </div> |
| </li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarDeploying" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Deploying</a> |
| <div class="dropdown-menu" aria-labelledby="navbarDeploying"> |
| <a class="dropdown-item" href="cluster-overview.html">Overview</a> |
| <a class="dropdown-item" href="submitting-applications.html">Submitting Applications</a> |
| <div class="dropdown-divider"></div> |
| <a class="dropdown-item" href="spark-standalone.html">Spark Standalone</a> |
| <a class="dropdown-item" href="running-on-mesos.html">Mesos</a> |
| <a class="dropdown-item" href="running-on-yarn.html">YARN</a> |
| <a class="dropdown-item" href="running-on-kubernetes.html">Kubernetes</a> |
| </div> |
| </li> |
| |
| <li class="nav-item dropdown"> |
| <a href="#" class="nav-link dropdown-toggle" id="navbarMore" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">More</a> |
| <div class="dropdown-menu" aria-labelledby="navbarMore"> |
| <a class="dropdown-item" href="configuration.html">Configuration</a> |
| <a class="dropdown-item" href="monitoring.html">Monitoring</a> |
| <a class="dropdown-item" href="tuning.html">Tuning Guide</a> |
| <a class="dropdown-item" href="job-scheduling.html">Job Scheduling</a> |
| <a class="dropdown-item" href="security.html">Security</a> |
| <a class="dropdown-item" href="hardware-provisioning.html">Hardware Provisioning</a> |
| <a class="dropdown-item" href="migration-guide.html">Migration Guide</a> |
| <div class="dropdown-divider"></div> |
| <a class="dropdown-item" href="building-spark.html">Building Spark</a> |
| <a class="dropdown-item" href="https://spark.apache.org/contributing.html">Contributing to Spark</a> |
| <a class="dropdown-item" href="https://spark.apache.org/third-party-projects.html">Third Party Projects</a> |
| </div> |
| </li> |
| |
| <li class="nav-item"> |
| <input type="text" id="docsearch-input" placeholder="Search the docs…"> |
| </li> |
| </ul> |
| <!--<span class="navbar-text navbar-right"><span class="version-text">v3.5.0</span></span>--> |
| </div> |
| </nav> |
| |
| |
| |
| <div class="container"> |
| |
| |
| |
| <div class="left-menu-wrapper"> |
| <div class="left-menu"> |
| <h3><a href="sql-programming-guide.html">Spark SQL Guide</a></h3> |
| |
| <ul> |
| |
| <li> |
| <a href="sql-getting-started.html"> |
| |
| Getting Started |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-data-sources.html"> |
| |
| Data Sources |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-performance-tuning.html"> |
| |
| Performance Tuning |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-distributed-sql-engine.html"> |
| |
| Distributed SQL Engine |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-pyspark-pandas-with-arrow.html"> |
| |
| PySpark Usage Guide for Pandas with Apache Arrow |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-migration-guide.html"> |
| |
| Migration Guide |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-ref.html"> |
| |
| SQL Reference |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions.html"> |
| |
| Error Conditions |
| |
| </a> |
| </li> |
| |
| |
| |
| <ul> |
| |
| <li> |
| <a href="sql-error-conditions-sqlstates.html"> |
| |
| SQLSTATE Codes |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-connect-error-class.html"> |
| |
| CONNECT error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-datatype-mismatch-error-class.html"> |
| |
| DATATYPE_MISMATCH error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-incompatible-data-to-table-error-class.html"> |
| |
| INCOMPATIBLE_DATA_FOR_TABLE error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-incomplete-type-definition-error-class.html"> |
| |
| INCOMPLETE_TYPE_DEFINITION error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-inconsistent-behavior-cross-version-error-class.html"> |
| |
| INCONSISTENT_BEHAVIOR_CROSS_VERSION error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-invalid-format-error-class.html"> |
| |
| INVALID_FORMAT error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-invalid-options-error-class.html"> |
| |
| INVALID_OPTIONS error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-invalid-parameter-value-error-class.html"> |
| |
| INVALID_PARAMETER_VALUE error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-invalid-schema-error-class.html"> |
| |
| INVALID_SCHEMA error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-invalid-subquery-expression-error-class.html"> |
| |
| INVALID_SUBQUERY_EXPRESSION error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-not-null-constraint-violation-error-class.html"> |
| |
| NOT_NULL_CONSTRAINT_VIOLATION error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unresolved-column-error-class.html"> |
| |
| UNRESOLVED_COLUMN error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unresolved-field-error-class.html"> |
| |
| UNRESOLVED_FIELD error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unresolved-map-key-error-class.html"> |
| |
| UNRESOLVED_MAP_KEY error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unsupported-deserializer-error-class.html"> |
| |
| UNSUPPORTED_DESERIALIZER error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unsupported-feature-error-class.html"> |
| |
| UNSUPPORTED_FEATURE error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unsupported-generator-error-class.html"> |
| |
| UNSUPPORTED_GENERATOR error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unsupported-save-mode-error-class.html"> |
| |
| UNSUPPORTED_SAVE_MODE error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-unsupported-subquery-expression-category-error-class.html"> |
| |
| UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY error class |
| |
| </a> |
| </li> |
| |
| |
| |
| <li> |
| <a href="sql-error-conditions-wrong-num-args-error-class.html"> |
| |
| WRONG_NUM_ARGS error class |
| |
| </a> |
| </li> |
| |
| |
| |
| </ul> |
| |
| |
| |
| </ul> |
| |
| </div> |
| </div> |
| |
| <input id="nav-trigger" class="nav-trigger" checked type="checkbox"> |
| <label for="nav-trigger"></label> |
| <div class="content-with-sidebar mr-3" id="content"> |
| |
| <h1 class="title">Error Conditions</h1> |
| |
| |
| <p>This is a list of common, named error conditions returned by Spark SQL.</p> |
| |
| <p>Also see <a href="sql-error-conditions-sqlstates.html">SQLSTATE Codes</a>.</p> |
| |
| <h3 id="aggregate_function_with_nondeterministic_expression">AGGREGATE_FUNCTION_WITH_NONDETERMINISTIC_EXPRESSION</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Non-deterministic expression <code class="language-plaintext highlighter-rouge"><sqlExpr></code> should not appear in the arguments of an aggregate function.</p> |
| |
| <h3 id="all_partition_columns_not_allowed">ALL_PARTITION_COLUMNS_NOT_ALLOWED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot use all columns for partition columns.</p> |
| |
| <h3 id="alter_table_column_descriptor_duplicate">ALTER_TABLE_COLUMN_DESCRIPTOR_DUPLICATE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42710</a></p> |
| |
| <p>ALTER TABLE <code class="language-plaintext highlighter-rouge"><type></code> column <code class="language-plaintext highlighter-rouge"><columnName></code> specifies descriptor “<code class="language-plaintext highlighter-rouge"><optionName></code>” more than once, which is invalid.</p> |
| |
| <h3 id="ambiguous_alias_in_nested_cte">AMBIGUOUS_ALIAS_IN_NESTED_CTE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Name <code class="language-plaintext highlighter-rouge"><name></code> is ambiguous in nested CTE. |
| Please set <code class="language-plaintext highlighter-rouge"><config></code> to “CORRECTED” so that name defined in inner CTE takes precedence. If set it to “LEGACY”, outer CTE definitions will take precedence. |
| See ‘<code class="language-plaintext highlighter-rouge"><docroot></code>/sql-migration-guide.html#query-engine’.</p> |
| |
| <h3 id="ambiguous_column_or_field">AMBIGUOUS_COLUMN_OR_FIELD</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42702</a></p> |
| |
| <p>Column or field <code class="language-plaintext highlighter-rouge"><name></code> is ambiguous and has <code class="language-plaintext highlighter-rouge"><n></code> matches.</p> |
| |
| <h3 id="ambiguous_lateral_column_alias">AMBIGUOUS_LATERAL_COLUMN_ALIAS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42702</a></p> |
| |
| <p>Lateral column alias <code class="language-plaintext highlighter-rouge"><name></code> is ambiguous and has <code class="language-plaintext highlighter-rouge"><n></code> matches.</p> |
| |
| <h3 id="ambiguous_reference">AMBIGUOUS_REFERENCE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42704</a></p> |
| |
| <p>Reference <code class="language-plaintext highlighter-rouge"><name></code> is ambiguous, could be: <code class="language-plaintext highlighter-rouge"><referenceNames></code>.</p> |
| |
| <h3 id="ambiguous_reference_to_fields">AMBIGUOUS_REFERENCE_TO_FIELDS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Ambiguous reference to the field <code class="language-plaintext highlighter-rouge"><field></code>. It appears <code class="language-plaintext highlighter-rouge"><count></code> times in the schema.</p> |
| |
| <h3 id="arithmetic_overflow">ARITHMETIC_OVERFLOW</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code>.<code class="language-plaintext highlighter-rouge"><alternative></code> If necessary set <code class="language-plaintext highlighter-rouge"><config></code> to “false” to bypass this error.</p> |
| |
| <h3 id="as_of_join"><a href="sql-error-conditions-as-of-join-error-class.html">AS_OF_JOIN</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid as-of join.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-as-of-join-error-class.html">AS_OF_JOIN</a></p> |
| |
| <h3 id="batch_metadata_not_found">BATCH_METADATA_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K03</a></p> |
| |
| <p>Unable to find batch <code class="language-plaintext highlighter-rouge"><batchMetadataFile></code>.</p> |
| |
| <h3 id="binary_arithmetic_overflow">BINARY_ARITHMETIC_OVERFLOW</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><value1></code> <code class="language-plaintext highlighter-rouge"><symbol></code> <code class="language-plaintext highlighter-rouge"><value2></code> caused overflow.</p> |
| |
| <h3 id="call_on_streaming_dataset_unsupported">CALL_ON_STREAMING_DATASET_UNSUPPORTED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The method <code class="language-plaintext highlighter-rouge"><methodName></code> can not be called on streaming Dataset/DataFrame.</p> |
| |
| <h3 id="cannot_cast_datatype">CANNOT_CAST_DATATYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42846</a></p> |
| |
| <p>Cannot cast <code class="language-plaintext highlighter-rouge"><sourceType></code> to <code class="language-plaintext highlighter-rouge"><targetType></code>.</p> |
| |
| <h3 id="cannot_convert_protobuf_field_type_to_sql_type">CANNOT_CONVERT_PROTOBUF_FIELD_TYPE_TO_SQL_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot convert Protobuf <code class="language-plaintext highlighter-rouge"><protobufColumn></code> to SQL <code class="language-plaintext highlighter-rouge"><sqlColumn></code> because schema is incompatible (protobufType = <code class="language-plaintext highlighter-rouge"><protobufType></code>, sqlType = <code class="language-plaintext highlighter-rouge"><sqlType></code>).</p> |
| |
| <h3 id="cannot_convert_protobuf_message_type_to_sql_type">CANNOT_CONVERT_PROTOBUF_MESSAGE_TYPE_TO_SQL_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Unable to convert <code class="language-plaintext highlighter-rouge"><protobufType></code> of Protobuf to SQL type <code class="language-plaintext highlighter-rouge"><toType></code>.</p> |
| |
| <h3 id="cannot_convert_sql_type_to_protobuf_field_type">CANNOT_CONVERT_SQL_TYPE_TO_PROTOBUF_FIELD_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot convert SQL <code class="language-plaintext highlighter-rouge"><sqlColumn></code> to Protobuf <code class="language-plaintext highlighter-rouge"><protobufColumn></code> because schema is incompatible (protobufType = <code class="language-plaintext highlighter-rouge"><protobufType></code>, sqlType = <code class="language-plaintext highlighter-rouge"><sqlType></code>).</p> |
| |
| <h3 id="cannot_convert_sql_value_to_protobuf_enum_type">CANNOT_CONVERT_SQL_VALUE_TO_PROTOBUF_ENUM_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot convert SQL <code class="language-plaintext highlighter-rouge"><sqlColumn></code> to Protobuf <code class="language-plaintext highlighter-rouge"><protobufColumn></code> because <code class="language-plaintext highlighter-rouge"><data></code> is not in defined values for enum: <code class="language-plaintext highlighter-rouge"><enumString></code>.</p> |
| |
| <h3 id="cannot_decode_url">CANNOT_DECODE_URL</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22546</a></p> |
| |
| <p>The provided URL cannot be decoded: <code class="language-plaintext highlighter-rouge"><url></code>. Please ensure that the URL is properly formatted and try again.</p> |
| |
| <h3 id="cannot_invoke_in_transformations">CANNOT_INVOKE_IN_TRANSFORMATIONS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Dataset transformations and actions can only be invoked by the driver, not inside of other Dataset transformations; for example, dataset1.map(x => dataset2.values.count() * x) is invalid because the values transformation and count action cannot be performed inside of the dataset1.map transformation. For more information, see SPARK-28702.</p> |
| |
| <h3 id="cannot_load_function_class">CANNOT_LOAD_FUNCTION_CLASS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot load class <code class="language-plaintext highlighter-rouge"><className></code> when registering the function <code class="language-plaintext highlighter-rouge"><functionName></code>, please make sure it is on the classpath.</p> |
| |
| <h3 id="cannot_load_protobuf_class">CANNOT_LOAD_PROTOBUF_CLASS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Could not load Protobuf class with name <code class="language-plaintext highlighter-rouge"><protobufClassName></code>. <code class="language-plaintext highlighter-rouge"><explanation></code>.</p> |
| |
| <h3 id="cannot_merge_incompatible_data_type">CANNOT_MERGE_INCOMPATIBLE_DATA_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42825</a></p> |
| |
| <p>Failed to merge incompatible data types <code class="language-plaintext highlighter-rouge"><left></code> and <code class="language-plaintext highlighter-rouge"><right></code>. Please check the data types of the columns being merged and ensure that they are compatible. If necessary, consider casting the columns to compatible data types before attempting the merge.</p> |
| |
| <h3 id="cannot_merge_schemas">CANNOT_MERGE_SCHEMAS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42KD9</a></p> |
| |
| <p>Failed merging schemas: |
| Initial schema: |
| <code class="language-plaintext highlighter-rouge"><left></code> |
| Schema that cannot be merged with the initial schema: |
| <code class="language-plaintext highlighter-rouge"><right></code>.</p> |
| |
| <h3 id="cannot_modify_config">CANNOT_MODIFY_CONFIG</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-46-java-ddl-1">SQLSTATE: 46110</a></p> |
| |
| <p>Cannot modify the value of the Spark config: <code class="language-plaintext highlighter-rouge"><key></code>. |
| See also ‘<code class="language-plaintext highlighter-rouge"><docroot></code>/sql-migration-guide.html#ddl-statements’.</p> |
| |
| <h3 id="cannot_parse_decimal">CANNOT_PARSE_DECIMAL</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22018</a></p> |
| |
| <p>Cannot parse decimal. Please ensure that the input is a valid number with optional decimal point or comma separators.</p> |
| |
| <h3 id="cannot_parse_interval">CANNOT_PARSE_INTERVAL</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Unable to parse <code class="language-plaintext highlighter-rouge"><intervalString></code>. Please ensure that the value provided is in a valid format for defining an interval. You can reference the documentation for the correct format. If the issue persists, please double check that the input value is not null or empty and try again.</p> |
| |
| <h3 id="cannot_parse_json_field">CANNOT_PARSE_JSON_FIELD</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 2203G</a></p> |
| |
| <p>Cannot parse the field name <code class="language-plaintext highlighter-rouge"><fieldName></code> and the value <code class="language-plaintext highlighter-rouge"><fieldValue></code> of the JSON token type <code class="language-plaintext highlighter-rouge"><jsonType></code> to target Spark data type <code class="language-plaintext highlighter-rouge"><dataType></code>.</p> |
| |
| <h3 id="cannot_parse_protobuf_descriptor">CANNOT_PARSE_PROTOBUF_DESCRIPTOR</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Error parsing descriptor bytes into Protobuf FileDescriptorSet.</p> |
| |
| <h3 id="cannot_parse_timestamp">CANNOT_PARSE_TIMESTAMP</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22007</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code>. If necessary set <code class="language-plaintext highlighter-rouge"><ansiConfig></code> to “false” to bypass this error.</p> |
| |
| <h3 id="cannot_read_file_footer">CANNOT_READ_FILE_FOOTER</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Could not read footer for file: <code class="language-plaintext highlighter-rouge"><file></code>. Please ensure that the file is in either ORC or Parquet format. If not, please convert it to a valid format. If the file is in the valid format, please check if it is corrupt. If it is, you can choose to either ignore it or fix the corruption.</p> |
| |
| <h3 id="cannot_recognize_hive_type">CANNOT_RECOGNIZE_HIVE_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 429BB</a></p> |
| |
| <p>Cannot recognize hive type string: <code class="language-plaintext highlighter-rouge"><fieldType></code>, column: <code class="language-plaintext highlighter-rouge"><fieldName></code>. The specified data type for the field cannot be recognized by Spark SQL. Please check the data type of the specified field and ensure that it is a valid Spark SQL data type. Refer to the Spark SQL documentation for a list of valid data types and their format. If the data type is correct, please ensure that you are using a supported version of Spark SQL.</p> |
| |
| <h3 id="cannot_rename_across_schema">CANNOT_RENAME_ACROSS_SCHEMA</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0AKD0</a></p> |
| |
| <p>Renaming a <code class="language-plaintext highlighter-rouge"><type></code> across schemas is not allowed.</p> |
| |
| <h3 id="cannot_resolve_star_expand">CANNOT_RESOLVE_STAR_EXPAND</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot resolve <code class="language-plaintext highlighter-rouge"><targetString></code>.* given input columns <code class="language-plaintext highlighter-rouge"><columns></code>. Please check that the specified table or struct exists and is accessible in the input columns.</p> |
| |
| <h3 id="cannot_restore_permissions_for_path">CANNOT_RESTORE_PERMISSIONS_FOR_PATH</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Failed to set permissions on created path <code class="language-plaintext highlighter-rouge"><path></code> back to <code class="language-plaintext highlighter-rouge"><permission></code>.</p> |
| |
| <h3 id="cannot_update_field"><a href="sql-error-conditions-cannot-update-field-error-class.html">CANNOT_UPDATE_FIELD</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot update <code class="language-plaintext highlighter-rouge"><table></code> field <code class="language-plaintext highlighter-rouge"><fieldName></code> type:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-cannot-update-field-error-class.html">CANNOT_UPDATE_FIELD</a></p> |
| |
| <h3 id="cannot_up_cast_datatype">CANNOT_UP_CAST_DATATYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot up cast <code class="language-plaintext highlighter-rouge"><expression></code> from <code class="language-plaintext highlighter-rouge"><sourceType></code> to <code class="language-plaintext highlighter-rouge"><targetType></code>. |
| <code class="language-plaintext highlighter-rouge"><details></code></p> |
| |
| <h3 id="cast_invalid_input">CAST_INVALID_INPUT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22018</a></p> |
| |
| <p>The value <code class="language-plaintext highlighter-rouge"><expression></code> of the type <code class="language-plaintext highlighter-rouge"><sourceType></code> cannot be cast to <code class="language-plaintext highlighter-rouge"><targetType></code> because it is malformed. Correct the value as per the syntax, or change its target type. Use <code class="language-plaintext highlighter-rouge">try_cast</code> to tolerate malformed input and return NULL instead. If necessary set <code class="language-plaintext highlighter-rouge"><ansiConfig></code> to “false” to bypass this error.</p> |
| |
| <h3 id="cast_overflow">CAST_OVERFLOW</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>The value <code class="language-plaintext highlighter-rouge"><value></code> of the type <code class="language-plaintext highlighter-rouge"><sourceType></code> cannot be cast to <code class="language-plaintext highlighter-rouge"><targetType></code> due to an overflow. Use <code class="language-plaintext highlighter-rouge">try_cast</code> to tolerate overflow and return NULL instead. If necessary set <code class="language-plaintext highlighter-rouge"><ansiConfig></code> to “false” to bypass this error.</p> |
| |
| <h3 id="cast_overflow_in_table_insert">CAST_OVERFLOW_IN_TABLE_INSERT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>Fail to insert a value of <code class="language-plaintext highlighter-rouge"><sourceType></code> type into the <code class="language-plaintext highlighter-rouge"><targetType></code> type column <code class="language-plaintext highlighter-rouge"><columnName></code> due to an overflow. Use <code class="language-plaintext highlighter-rouge">try_cast</code> on the input value to tolerate overflow and return NULL instead.</p> |
| |
| <h3 id="codec_not_available">CODEC_NOT_AVAILABLE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The codec <code class="language-plaintext highlighter-rouge"><codecName></code> is not available. Consider to set the config <code class="language-plaintext highlighter-rouge"><configKey></code> to <code class="language-plaintext highlighter-rouge"><configVal></code>.</p> |
| |
| <h3 id="codec_short_name_not_found">CODEC_SHORT_NAME_NOT_FOUND</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot find a short name for the codec <code class="language-plaintext highlighter-rouge"><codecName></code>.</p> |
| |
| <h3 id="column_aliases_is_not_allowed">COLUMN_ALIASES_IS_NOT_ALLOWED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Columns aliases are not allowed in <code class="language-plaintext highlighter-rouge"><op></code>.</p> |
| |
| <h3 id="column_already_exists">COLUMN_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42711</a></p> |
| |
| <p>The column <code class="language-plaintext highlighter-rouge"><columnName></code> already exists. Consider to choose another name or rename the existing column.</p> |
| |
| <h3 id="column_not_defined_in_table">COLUMN_NOT_DEFINED_IN_TABLE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><colType></code> column <code class="language-plaintext highlighter-rouge"><colName></code> is not defined in table <code class="language-plaintext highlighter-rouge"><tableName></code>, defined table columns are: <code class="language-plaintext highlighter-rouge"><tableCols></code>.</p> |
| |
| <h3 id="column_not_found">COLUMN_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42703</a></p> |
| |
| <p>The column <code class="language-plaintext highlighter-rouge"><colName></code> cannot be found. Verify the spelling and correctness of the column name according to the SQL config <code class="language-plaintext highlighter-rouge"><caseSensitiveConfig></code>.</p> |
| |
| <h3 id="comparator_returns_null">COMPARATOR_RETURNS_NULL</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The comparator has returned a NULL for a comparison between <code class="language-plaintext highlighter-rouge"><firstValue></code> and <code class="language-plaintext highlighter-rouge"><secondValue></code>. It should return a positive integer for “greater than”, 0 for “equal” and a negative integer for “less than”. To revert to deprecated behavior where NULL is treated as 0 (equal), you must set “spark.sql.legacy.allowNullComparisonResultInArraySort” to “true”.</p> |
| |
| <h3 id="concurrent_query">CONCURRENT_QUERY</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Another instance of this query was just started by a concurrent session.</p> |
| |
| <h3 id="concurrent_stream_log_update">CONCURRENT_STREAM_LOG_UPDATE</h3> |
| |
| <p>SQLSTATE: 40000</p> |
| |
| <p>Concurrent update to the log. Multiple streaming jobs detected for <code class="language-plaintext highlighter-rouge"><batchId></code>. |
| Please make sure only one streaming job runs on a specific checkpoint location at a time.</p> |
| |
| <h3 id="connect"><a href="sql-error-conditions-connect-error-class.html">CONNECT</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Generic Spark Connect error.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-connect-error-class.html">CONNECT</a></p> |
| |
| <h3 id="conversion_invalid_input">CONVERSION_INVALID_INPUT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22018</a></p> |
| |
| <p>The value <code class="language-plaintext highlighter-rouge"><str></code> (<code class="language-plaintext highlighter-rouge"><fmt></code>) cannot be converted to <code class="language-plaintext highlighter-rouge"><targetType></code> because it is malformed. Correct the value as per the syntax, or change its format. Use <code class="language-plaintext highlighter-rouge"><suggestion></code> to tolerate malformed input and return NULL instead.</p> |
| |
| <h3 id="create_permanent_view_without_alias">CREATE_PERMANENT_VIEW_WITHOUT_ALIAS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Not allowed to create the permanent view <code class="language-plaintext highlighter-rouge"><name></code> without explicitly assigning an alias for the expression <code class="language-plaintext highlighter-rouge"><attr></code>.</p> |
| |
| <h3 id="create_table_column_descriptor_duplicate">CREATE_TABLE_COLUMN_DESCRIPTOR_DUPLICATE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42710</a></p> |
| |
| <p>CREATE TABLE column <code class="language-plaintext highlighter-rouge"><columnName></code> specifies descriptor “<code class="language-plaintext highlighter-rouge"><optionName></code>” more than once, which is invalid.</p> |
| |
| <h3 id="create_view_column_arity_mismatch"><a href="sql-error-conditions-create-view-column-arity-mismatch-error-class.html">CREATE_VIEW_COLUMN_ARITY_MISMATCH</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-21-cardinality-violation">SQLSTATE: 21S01</a></p> |
| |
| <p>Cannot create view <code class="language-plaintext highlighter-rouge"><viewName></code>, the reason is</p> |
| |
| <p>For more details see <a href="sql-error-conditions-create-view-column-arity-mismatch-error-class.html">CREATE_VIEW_COLUMN_ARITY_MISMATCH</a></p> |
| |
| <h3 id="datatype_mismatch"><a href="sql-error-conditions-datatype-mismatch-error-class.html">DATATYPE_MISMATCH</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K09</a></p> |
| |
| <p>Cannot resolve <code class="language-plaintext highlighter-rouge"><sqlExpr></code> due to data type mismatch:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-datatype-mismatch-error-class.html">DATATYPE_MISMATCH</a></p> |
| |
| <h3 id="datatype_missing_size">DATATYPE_MISSING_SIZE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K01</a></p> |
| |
| <p>DataType <code class="language-plaintext highlighter-rouge"><type></code> requires a length parameter, for example <code class="language-plaintext highlighter-rouge"><type></code>(10). Please specify the length.</p> |
| |
| <h3 id="data_source_not_found">DATA_SOURCE_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K02</a></p> |
| |
| <p>Failed to find the data source: <code class="language-plaintext highlighter-rouge"><provider></code>. Please find packages at <code class="language-plaintext highlighter-rouge">https://spark.apache.org/third-party-projects.html</code>.</p> |
| |
| <h3 id="datetime_overflow">DATETIME_OVERFLOW</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22008</a></p> |
| |
| <p>Datetime operation overflow: <code class="language-plaintext highlighter-rouge"><operation></code>.</p> |
| |
| <h3 id="decimal_precision_exceeds_max_precision">DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>Decimal precision <code class="language-plaintext highlighter-rouge"><precision></code> exceeds max precision <code class="language-plaintext highlighter-rouge"><maxPrecision></code>.</p> |
| |
| <h3 id="default_database_not_exists">DEFAULT_DATABASE_NOT_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42704</a></p> |
| |
| <p>Default database <code class="language-plaintext highlighter-rouge"><defaultDatabase></code> does not exist, please create it first or change default database to <code class="language-plaintext highlighter-rouge"><defaultDatabase></code>.</p> |
| |
| <h3 id="distinct_window_function_unsupported">DISTINCT_WINDOW_FUNCTION_UNSUPPORTED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Distinct window functions are not supported: <code class="language-plaintext highlighter-rouge"><windowExpr></code>.</p> |
| |
| <h3 id="divide_by_zero">DIVIDE_BY_ZERO</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22012</a></p> |
| |
| <p>Division by zero. Use <code class="language-plaintext highlighter-rouge">try_divide</code> to tolerate divisor being 0 and return NULL instead. If necessary set <code class="language-plaintext highlighter-rouge"><config></code> to “false” to bypass this error.</p> |
| |
| <h3 id="duplicated_field_name_in_arrow_struct">DUPLICATED_FIELD_NAME_IN_ARROW_STRUCT</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Duplicated field names in Arrow Struct are not allowed, got <code class="language-plaintext highlighter-rouge"><fieldNames></code>.</p> |
| |
| <h3 id="duplicated_map_key">DUPLICATED_MAP_KEY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-23-integrity-constraint-violation">SQLSTATE: 23505</a></p> |
| |
| <p>Duplicate map key <code class="language-plaintext highlighter-rouge"><key></code> was found, please check the input data. If you want to remove the duplicated keys, you can set <code class="language-plaintext highlighter-rouge"><mapKeyDedupPolicy></code> to “LAST_WIN” so that the key inserted at last takes precedence.</p> |
| |
| <h3 id="duplicated_metrics_name">DUPLICATED_METRICS_NAME</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The metric name is not unique: <code class="language-plaintext highlighter-rouge"><metricName></code>. The same name cannot be used for metrics with different results. However multiple instances of metrics with with same result and name are allowed (e.g. self-joins).</p> |
| |
| <h3 id="duplicate_clauses">DUPLICATE_CLAUSES</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Found duplicate clauses: <code class="language-plaintext highlighter-rouge"><clauseName></code>. Please, remove one of them.</p> |
| |
| <h3 id="duplicate_key">DUPLICATE_KEY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-23-integrity-constraint-violation">SQLSTATE: 23505</a></p> |
| |
| <p>Found duplicate keys <code class="language-plaintext highlighter-rouge"><keyColumn></code>.</p> |
| |
| <h3 id="duplicate_routine_parameter_assignment"><a href="sql-error-conditions-duplicate-routine-parameter-assignment-error-class.html">DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENT</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 4274K</a></p> |
| |
| <p>Call to function <code class="language-plaintext highlighter-rouge"><functionName></code> is invalid because it includes multiple argument assignments to the same parameter name <code class="language-plaintext highlighter-rouge"><parameterName></code>.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-duplicate-routine-parameter-assignment-error-class.html">DUPLICATE_ROUTINE_PARAMETER_ASSIGNMENT</a></p> |
| |
| <h3 id="empty_json_field_value">EMPTY_JSON_FIELD_VALUE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42604</a></p> |
| |
| <p>Failed to parse an empty string for data type <code class="language-plaintext highlighter-rouge"><dataType></code>.</p> |
| |
| <h3 id="encoder_not_found">ENCODER_NOT_FOUND</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Not found an encoder of the type <code class="language-plaintext highlighter-rouge"><typeName></code> to Spark SQL internal representation. Consider to change the input type to one of supported at ‘<code class="language-plaintext highlighter-rouge"><docroot></code>/sql-ref-datatypes.html’.</p> |
| |
| <h3 id="event_time_is_not_on_timestamp_type">EVENT_TIME_IS_NOT_ON_TIMESTAMP_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The event time <code class="language-plaintext highlighter-rouge"><eventName></code> has the invalid type <code class="language-plaintext highlighter-rouge"><eventType></code>, but expected “TIMESTAMP”.</p> |
| |
| <h3 id="exceed_limit_length">EXCEED_LIMIT_LENGTH</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Exceeds char/varchar type length limitation: <code class="language-plaintext highlighter-rouge"><limit></code>.</p> |
| |
| <h3 id="expression_type_is_not_orderable">EXPRESSION_TYPE_IS_NOT_ORDERABLE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Column expression <code class="language-plaintext highlighter-rouge"><expr></code> cannot be sorted because its type <code class="language-plaintext highlighter-rouge"><exprType></code> is not orderable.</p> |
| |
| <h3 id="failed_execute_udf">FAILED_EXECUTE_UDF</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-39-external-routine-invocation-exception">SQLSTATE: 39000</a></p> |
| |
| <p>Failed to execute user defined function (<code class="language-plaintext highlighter-rouge"><functionName></code>: (<code class="language-plaintext highlighter-rouge"><signature></code>) => <code class="language-plaintext highlighter-rouge"><result></code>).</p> |
| |
| <h3 id="failed_function_call">FAILED_FUNCTION_CALL</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-38-external-routine-exception">SQLSTATE: 38000</a></p> |
| |
| <p>Failed preparing of the function <code class="language-plaintext highlighter-rouge"><funcName></code> for call. Please, double check function’s arguments.</p> |
| |
| <h3 id="failed_parse_struct_type">FAILED_PARSE_STRUCT_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22018</a></p> |
| |
| <p>Failed parsing struct: <code class="language-plaintext highlighter-rouge"><raw></code>.</p> |
| |
| <h3 id="failed_rename_path">FAILED_RENAME_PATH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K04</a></p> |
| |
| <p>Failed to rename <code class="language-plaintext highlighter-rouge"><sourcePath></code> to <code class="language-plaintext highlighter-rouge"><targetPath></code> as destination already exists.</p> |
| |
| <h3 id="failed_rename_temp_file">FAILED_RENAME_TEMP_FILE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Failed to rename temp file <code class="language-plaintext highlighter-rouge"><srcPath></code> to <code class="language-plaintext highlighter-rouge"><dstPath></code> as FileSystem.rename returned false.</p> |
| |
| <h3 id="fields_already_exists">FIELDS_ALREADY_EXISTS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot <code class="language-plaintext highlighter-rouge"><op></code> column, because <code class="language-plaintext highlighter-rouge"><fieldNames></code> already exists in <code class="language-plaintext highlighter-rouge"><struct></code>.</p> |
| |
| <h3 id="field_not_found">FIELD_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42704</a></p> |
| |
| <p>No such struct field <code class="language-plaintext highlighter-rouge"><fieldName></code> in <code class="language-plaintext highlighter-rouge"><fields></code>.</p> |
| |
| <h3 id="forbidden_operation">FORBIDDEN_OPERATION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42809</a></p> |
| |
| <p>The operation <code class="language-plaintext highlighter-rouge"><statement></code> is not allowed on the <code class="language-plaintext highlighter-rouge"><objectType></code>: <code class="language-plaintext highlighter-rouge"><objectName></code>.</p> |
| |
| <h3 id="generated_column_with_default_value">GENERATED_COLUMN_WITH_DEFAULT_VALUE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>A column cannot have both a default value and a generation expression but column <code class="language-plaintext highlighter-rouge"><colName></code> has default value: (<code class="language-plaintext highlighter-rouge"><defaultValue></code>) and generation expression: (<code class="language-plaintext highlighter-rouge"><genExpr></code>).</p> |
| |
| <h3 id="graphite_sink_invalid_protocol">GRAPHITE_SINK_INVALID_PROTOCOL</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid Graphite protocol: <code class="language-plaintext highlighter-rouge"><protocol></code>.</p> |
| |
| <h3 id="graphite_sink_property_missing">GRAPHITE_SINK_PROPERTY_MISSING</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Graphite sink requires ‘<code class="language-plaintext highlighter-rouge"><property></code>’ property.</p> |
| |
| <h3 id="grouping_column_mismatch">GROUPING_COLUMN_MISMATCH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42803</a></p> |
| |
| <p>Column of grouping (<code class="language-plaintext highlighter-rouge"><grouping></code>) can’t be found in grouping columns <code class="language-plaintext highlighter-rouge"><groupingColumns></code>.</p> |
| |
| <h3 id="grouping_id_column_mismatch">GROUPING_ID_COLUMN_MISMATCH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42803</a></p> |
| |
| <p>Columns of grouping_id (<code class="language-plaintext highlighter-rouge"><groupingIdColumn></code>) does not match grouping columns (<code class="language-plaintext highlighter-rouge"><groupByColumns></code>).</p> |
| |
| <h3 id="grouping_size_limit_exceeded">GROUPING_SIZE_LIMIT_EXCEEDED</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-54-program-limit-exceeded">SQLSTATE: 54000</a></p> |
| |
| <p>Grouping sets size cannot be greater than <code class="language-plaintext highlighter-rouge"><maxSize></code>.</p> |
| |
| <h3 id="group_by_aggregate">GROUP_BY_AGGREGATE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42903</a></p> |
| |
| <p>Aggregate functions are not allowed in GROUP BY, but found <code class="language-plaintext highlighter-rouge"><sqlExpr></code>.</p> |
| |
| <h3 id="group_by_pos_aggregate">GROUP_BY_POS_AGGREGATE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42903</a></p> |
| |
| <p>GROUP BY <code class="language-plaintext highlighter-rouge"><index></code> refers to an expression <code class="language-plaintext highlighter-rouge"><aggExpr></code> that contains an aggregate function. Aggregate functions are not allowed in GROUP BY.</p> |
| |
| <h3 id="group_by_pos_out_of_range">GROUP_BY_POS_OUT_OF_RANGE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42805</a></p> |
| |
| <p>GROUP BY position <code class="language-plaintext highlighter-rouge"><index></code> is not in select list (valid range is [1, <code class="language-plaintext highlighter-rouge"><size></code>]).</p> |
| |
| <h3 id="group_expression_type_is_not_orderable">GROUP_EXPRESSION_TYPE_IS_NOT_ORDERABLE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The expression <code class="language-plaintext highlighter-rouge"><sqlExpr></code> cannot be used as a grouping expression because its data type <code class="language-plaintext highlighter-rouge"><dataType></code> is not an orderable data type.</p> |
| |
| <h3 id="hll_invalid_input_sketch_buffer">HLL_INVALID_INPUT_SKETCH_BUFFER</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid call to <code class="language-plaintext highlighter-rouge"><function></code>; only valid HLL sketch buffers are supported as inputs (such as those produced by the <code class="language-plaintext highlighter-rouge">hll_sketch_agg</code> function).</p> |
| |
| <h3 id="hll_invalid_lg_k">HLL_INVALID_LG_K</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid call to <code class="language-plaintext highlighter-rouge"><function></code>; the <code class="language-plaintext highlighter-rouge">lgConfigK</code> value must be between <code class="language-plaintext highlighter-rouge"><min></code> and <code class="language-plaintext highlighter-rouge"><max></code>, inclusive: <code class="language-plaintext highlighter-rouge"><value></code>.</p> |
| |
| <h3 id="hll_union_different_lg_k">HLL_UNION_DIFFERENT_LG_K</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Sketches have different <code class="language-plaintext highlighter-rouge">lgConfigK</code> values: <code class="language-plaintext highlighter-rouge"><left></code> and <code class="language-plaintext highlighter-rouge"><right></code>. Set the <code class="language-plaintext highlighter-rouge">allowDifferentLgConfigK</code> parameter to true to call <code class="language-plaintext highlighter-rouge"><function></code> with different <code class="language-plaintext highlighter-rouge">lgConfigK</code> values.</p> |
| |
| <h3 id="identifier_too_many_name_parts">IDENTIFIER_TOO_MANY_NAME_PARTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42601</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><identifier></code> is not a valid identifier as it has more than 2 name parts.</p> |
| |
| <h3 id="incomparable_pivot_column">INCOMPARABLE_PIVOT_COLUMN</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42818</a></p> |
| |
| <p>Invalid pivot column <code class="language-plaintext highlighter-rouge"><columnName></code>. Pivot columns must be comparable.</p> |
| |
| <h3 id="incompatible_column_type">INCOMPATIBLE_COLUMN_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42825</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><operator></code> can only be performed on tables with compatible column types. The <code class="language-plaintext highlighter-rouge"><columnOrdinalNumber></code> column of the <code class="language-plaintext highlighter-rouge"><tableOrdinalNumber></code> table is <code class="language-plaintext highlighter-rouge"><dataType1></code> type which is not compatible with <code class="language-plaintext highlighter-rouge"><dataType2></code> at the same column of the first table.<code class="language-plaintext highlighter-rouge"><hint></code>.</p> |
| |
| <h3 id="incompatible_datasource_register">INCOMPATIBLE_DATASOURCE_REGISTER</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Detected an incompatible DataSourceRegister. Please remove the incompatible library from classpath or upgrade it. Error: <code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="incompatible_data_for_table"><a href="sql-error-conditions-incompatible-data-for-table-error-class.html">INCOMPATIBLE_DATA_FOR_TABLE</a></h3> |
| |
| <p>SQLSTATE: KD000</p> |
| |
| <p>Cannot write incompatible data for the table <code class="language-plaintext highlighter-rouge"><tableName></code>:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-incompatible-data-for-table-error-class.html">INCOMPATIBLE_DATA_FOR_TABLE</a></p> |
| |
| <h3 id="incompatible_join_types">INCOMPATIBLE_JOIN_TYPES</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42613</a></p> |
| |
| <p>The join types <code class="language-plaintext highlighter-rouge"><joinType1></code> and <code class="language-plaintext highlighter-rouge"><joinType2></code> are incompatible.</p> |
| |
| <h3 id="incompatible_view_schema_change">INCOMPATIBLE_VIEW_SCHEMA_CHANGE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The SQL query of view <code class="language-plaintext highlighter-rouge"><viewName></code> has an incompatible schema change and column <code class="language-plaintext highlighter-rouge"><colName></code> cannot be resolved. Expected <code class="language-plaintext highlighter-rouge"><expectedNum></code> columns named <code class="language-plaintext highlighter-rouge"><colName></code> but got <code class="language-plaintext highlighter-rouge"><actualCols></code>. |
| Please try to re-create the view by running: <code class="language-plaintext highlighter-rouge"><suggestion></code>.</p> |
| |
| <h3 id="incomplete_type_definition"><a href="sql-error-conditions-incomplete-type-definition-error-class.html">INCOMPLETE_TYPE_DEFINITION</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K01</a></p> |
| |
| <p>Incomplete complex type:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-incomplete-type-definition-error-class.html">INCOMPLETE_TYPE_DEFINITION</a></p> |
| |
| <h3 id="inconsistent_behavior_cross_version"><a href="sql-error-conditions-inconsistent-behavior-cross-version-error-class.html">INCONSISTENT_BEHAVIOR_CROSS_VERSION</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K0B</a></p> |
| |
| <p>You may get a different result due to the upgrading to</p> |
| |
| <p>For more details see <a href="sql-error-conditions-inconsistent-behavior-cross-version-error-class.html">INCONSISTENT_BEHAVIOR_CROSS_VERSION</a></p> |
| |
| <h3 id="incorrect_end_offset">INCORRECT_END_OFFSET</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>Max offset with <code class="language-plaintext highlighter-rouge"><rowsPerSecond></code> rowsPerSecond is <code class="language-plaintext highlighter-rouge"><maxSeconds></code>, but it’s <code class="language-plaintext highlighter-rouge"><endSeconds></code> now.</p> |
| |
| <h3 id="incorrect_ramp_up_rate">INCORRECT_RAMP_UP_RATE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>Max offset with <code class="language-plaintext highlighter-rouge"><rowsPerSecond></code> rowsPerSecond is <code class="language-plaintext highlighter-rouge"><maxSeconds></code>, but ‘rampUpTimeSeconds’ is <code class="language-plaintext highlighter-rouge"><rampUpTimeSeconds></code>.</p> |
| |
| <h3 id="index_already_exists">INDEX_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42710</a></p> |
| |
| <p>Cannot create the index <code class="language-plaintext highlighter-rouge"><indexName></code> on table <code class="language-plaintext highlighter-rouge"><tableName></code> because it already exists.</p> |
| |
| <h3 id="index_not_found">INDEX_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42704</a></p> |
| |
| <p>Cannot find the index <code class="language-plaintext highlighter-rouge"><indexName></code> on table <code class="language-plaintext highlighter-rouge"><tableName></code>.</p> |
| |
| <h3 id="insert_column_arity_mismatch"><a href="sql-error-conditions-insert-column-arity-mismatch-error-class.html">INSERT_COLUMN_ARITY_MISMATCH</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-21-cardinality-violation">SQLSTATE: 21S01</a></p> |
| |
| <p>Cannot write to <code class="language-plaintext highlighter-rouge"><tableName></code>, the reason is</p> |
| |
| <p>For more details see <a href="sql-error-conditions-insert-column-arity-mismatch-error-class.html">INSERT_COLUMN_ARITY_MISMATCH</a></p> |
| |
| <h3 id="insert_partition_column_arity_mismatch">INSERT_PARTITION_COLUMN_ARITY_MISMATCH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-21-cardinality-violation">SQLSTATE: 21S01</a></p> |
| |
| <p>Cannot write to ‘<code class="language-plaintext highlighter-rouge"><tableName></code>’, <code class="language-plaintext highlighter-rouge"><reason></code>: |
| Table columns: <code class="language-plaintext highlighter-rouge"><tableColumns></code>. |
| Partition columns with static values: <code class="language-plaintext highlighter-rouge"><staticPartCols></code>. |
| Data columns: <code class="language-plaintext highlighter-rouge"><dataColumns></code>.</p> |
| |
| <h3 id="insufficient_table_property"><a href="sql-error-conditions-insufficient-table-property-error-class.html">INSUFFICIENT_TABLE_PROPERTY</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Can’t find table property:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-insufficient-table-property-error-class.html">INSUFFICIENT_TABLE_PROPERTY</a></p> |
| |
| <h3 id="internal_error">INTERNAL_ERROR</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-XX-internal-error">SQLSTATE: XX000</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="internal_error_broadcast">INTERNAL_ERROR_BROADCAST</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-XX-internal-error">SQLSTATE: XX000</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="internal_error_executor">INTERNAL_ERROR_EXECUTOR</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-XX-internal-error">SQLSTATE: XX000</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="internal_error_memory">INTERNAL_ERROR_MEMORY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-XX-internal-error">SQLSTATE: XX000</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="internal_error_network">INTERNAL_ERROR_NETWORK</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-XX-internal-error">SQLSTATE: XX000</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="internal_error_shuffle">INTERNAL_ERROR_SHUFFLE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-XX-internal-error">SQLSTATE: XX000</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="internal_error_storage">INTERNAL_ERROR_STORAGE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-XX-internal-error">SQLSTATE: XX000</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="interval_arithmetic_overflow">INTERVAL_ARITHMETIC_OVERFLOW</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22015</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><message></code>.<code class="language-plaintext highlighter-rouge"><alternative></code></p> |
| |
| <h3 id="interval_divided_by_zero">INTERVAL_DIVIDED_BY_ZERO</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22012</a></p> |
| |
| <p>Division by zero. Use <code class="language-plaintext highlighter-rouge">try_divide</code> to tolerate divisor being 0 and return NULL instead.</p> |
| |
| <h3 id="invalid_array_index">INVALID_ARRAY_INDEX</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>The index <code class="language-plaintext highlighter-rouge"><indexValue></code> is out of bounds. The array has <code class="language-plaintext highlighter-rouge"><arraySize></code> elements. Use the SQL function <code class="language-plaintext highlighter-rouge">get()</code> to tolerate accessing element at invalid index and return NULL instead. If necessary set <code class="language-plaintext highlighter-rouge"><ansiConfig></code> to “false” to bypass this error.</p> |
| |
| <h3 id="invalid_array_index_in_element_at">INVALID_ARRAY_INDEX_IN_ELEMENT_AT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>The index <code class="language-plaintext highlighter-rouge"><indexValue></code> is out of bounds. The array has <code class="language-plaintext highlighter-rouge"><arraySize></code> elements. Use <code class="language-plaintext highlighter-rouge">try_element_at</code> to tolerate accessing element at invalid index and return NULL instead. If necessary set <code class="language-plaintext highlighter-rouge"><ansiConfig></code> to “false” to bypass this error.</p> |
| |
| <h3 id="invalid_bitmap_position">INVALID_BITMAP_POSITION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>The 0-indexed bitmap position <code class="language-plaintext highlighter-rouge"><bitPosition></code> is out of bounds. The bitmap has <code class="language-plaintext highlighter-rouge"><bitmapNumBits></code> bits (<code class="language-plaintext highlighter-rouge"><bitmapNumBytes></code> bytes).</p> |
| |
| <h3 id="invalid_boundary"><a href="sql-error-conditions-invalid-boundary-error-class.html">INVALID_BOUNDARY</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The boundary <code class="language-plaintext highlighter-rouge"><boundary></code> is invalid: <code class="language-plaintext highlighter-rouge"><invalidValue></code>.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-boundary-error-class.html">INVALID_BOUNDARY</a></p> |
| |
| <h3 id="invalid_bucket_file">INVALID_BUCKET_FILE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid bucket file: <code class="language-plaintext highlighter-rouge"><path></code>.</p> |
| |
| <h3 id="invalid_byte_string">INVALID_BYTE_STRING</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The expected format is ByteString, but was <code class="language-plaintext highlighter-rouge"><unsupported></code> (<code class="language-plaintext highlighter-rouge"><class></code>).</p> |
| |
| <h3 id="invalid_column_name_as_path">INVALID_COLUMN_NAME_AS_PATH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-46-java-ddl-1">SQLSTATE: 46121</a></p> |
| |
| <p>The datasource <code class="language-plaintext highlighter-rouge"><datasource></code> cannot save the column <code class="language-plaintext highlighter-rouge"><columnName></code> because its name contains some characters that are not allowed in file paths. Please, use an alias to rename it.</p> |
| |
| <h3 id="invalid_column_or_field_data_type">INVALID_COLUMN_OR_FIELD_DATA_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Column or field <code class="language-plaintext highlighter-rouge"><name></code> is of type <code class="language-plaintext highlighter-rouge"><type></code> while it’s required to be <code class="language-plaintext highlighter-rouge"><expectedType></code>.</p> |
| |
| <h3 id="invalid_cursor"><a href="sql-error-conditions-invalid-cursor-error-class.html">INVALID_CURSOR</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-HY-cli-specific-condition">SQLSTATE: HY109</a></p> |
| |
| <p>The cursor is invalid.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-cursor-error-class.html">INVALID_CURSOR</a></p> |
| |
| <h3 id="invalid_default_value"><a href="sql-error-conditions-invalid-default-value-error-class.html">INVALID_DEFAULT_VALUE</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Failed to execute <code class="language-plaintext highlighter-rouge"><statement></code> command because the destination table column <code class="language-plaintext highlighter-rouge"><colName></code> has a DEFAULT value <code class="language-plaintext highlighter-rouge"><defaultValue></code>,</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-default-value-error-class.html">INVALID_DEFAULT_VALUE</a></p> |
| |
| <h3 id="invalid_driver_memory">INVALID_DRIVER_MEMORY</h3> |
| |
| <p>SQLSTATE: F0000</p> |
| |
| <p>System memory <code class="language-plaintext highlighter-rouge"><systemMemory></code> must be at least <code class="language-plaintext highlighter-rouge"><minSystemMemory></code>. Please increase heap size using the –driver-memory option or “<code class="language-plaintext highlighter-rouge"><config></code>” in Spark configuration.</p> |
| |
| <h3 id="invalid_empty_location">INVALID_EMPTY_LOCATION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K05</a></p> |
| |
| <p>The location name cannot be empty string, but <code class="language-plaintext highlighter-rouge"><location></code> was given.</p> |
| |
| <h3 id="invalid_esc">INVALID_ESC</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Found an invalid escape string: <code class="language-plaintext highlighter-rouge"><invalidEscape></code>. The escape string must contain only one character.</p> |
| |
| <h3 id="invalid_escape_char">INVALID_ESCAPE_CHAR</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p><code class="language-plaintext highlighter-rouge">EscapeChar</code> should be a string literal of length one, but got <code class="language-plaintext highlighter-rouge"><sqlExpr></code>.</p> |
| |
| <h3 id="invalid_executor_memory">INVALID_EXECUTOR_MEMORY</h3> |
| |
| <p>SQLSTATE: F0000</p> |
| |
| <p>Executor memory <code class="language-plaintext highlighter-rouge"><executorMemory></code> must be at least <code class="language-plaintext highlighter-rouge"><minSystemMemory></code>. Please increase executor memory using the –executor-memory option or “<code class="language-plaintext highlighter-rouge"><config></code>” in Spark configuration.</p> |
| |
| <h3 id="invalid_extract_base_field_type">INVALID_EXTRACT_BASE_FIELD_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Can’t extract a value from <code class="language-plaintext highlighter-rouge"><base></code>. Need a complex type [STRUCT, ARRAY, MAP] but got <code class="language-plaintext highlighter-rouge"><other></code>.</p> |
| |
| <h3 id="invalid_extract_field">INVALID_EXTRACT_FIELD</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42601</a></p> |
| |
| <p>Cannot extract <code class="language-plaintext highlighter-rouge"><field></code> from <code class="language-plaintext highlighter-rouge"><expr></code>.</p> |
| |
| <h3 id="invalid_extract_field_type">INVALID_EXTRACT_FIELD_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Field name should be a non-null string literal, but it’s <code class="language-plaintext highlighter-rouge"><extraction></code>.</p> |
| |
| <h3 id="invalid_field_name">INVALID_FIELD_NAME</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Field name <code class="language-plaintext highlighter-rouge"><fieldName></code> is invalid: <code class="language-plaintext highlighter-rouge"><path></code> is not a struct.</p> |
| |
| <h3 id="invalid_format"><a href="sql-error-conditions-invalid-format-error-class.html">INVALID_FORMAT</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42601</a></p> |
| |
| <p>The format is invalid: <code class="language-plaintext highlighter-rouge"><format></code>.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-format-error-class.html">INVALID_FORMAT</a></p> |
| |
| <h3 id="invalid_fraction_of_second">INVALID_FRACTION_OF_SECOND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22023</a></p> |
| |
| <p>The fraction of sec must be zero. Valid range is [0, 60]. If necessary set <code class="language-plaintext highlighter-rouge"><ansiConfig></code> to “false” to bypass this error.</p> |
| |
| <h3 id="invalid_handle"><a href="sql-error-conditions-invalid-handle-error-class.html">INVALID_HANDLE</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-HY-cli-specific-condition">SQLSTATE: HY000</a></p> |
| |
| <p>The handle <code class="language-plaintext highlighter-rouge"><handle></code> is invalid.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-handle-error-class.html">INVALID_HANDLE</a></p> |
| |
| <h3 id="invalid_hive_column_name">INVALID_HIVE_COLUMN_NAME</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot create the table <code class="language-plaintext highlighter-rouge"><tableName></code> having the nested column <code class="language-plaintext highlighter-rouge"><columnName></code> whose name contains invalid characters <code class="language-plaintext highlighter-rouge"><invalidChars></code> in Hive metastore.</p> |
| |
| <h3 id="invalid_identifier">INVALID_IDENTIFIER</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42602</a></p> |
| |
| <p>The identifier <code class="language-plaintext highlighter-rouge"><ident></code> is invalid. Please, consider quoting it with back-quotes as <code class="language-plaintext highlighter-rouge"><ident></code>.</p> |
| |
| <h3 id="invalid_index_of_zero">INVALID_INDEX_OF_ZERO</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>The index 0 is invalid. An index shall be either <code class="language-plaintext highlighter-rouge">< 0 or ></code> 0 (the first element has index 1).</p> |
| |
| <h3 id="invalid_inline_table"><a href="sql-error-conditions-invalid-inline-table-error-class.html">INVALID_INLINE_TABLE</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid inline table.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-inline-table-error-class.html">INVALID_INLINE_TABLE</a></p> |
| |
| <h3 id="invalid_json_root_field">INVALID_JSON_ROOT_FIELD</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22032</a></p> |
| |
| <p>Cannot convert JSON root field to target Spark type.</p> |
| |
| <h3 id="invalid_json_schema_map_type">INVALID_JSON_SCHEMA_MAP_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22032</a></p> |
| |
| <p>Input schema <code class="language-plaintext highlighter-rouge"><jsonSchema></code> can only contain STRING as a key type for a MAP.</p> |
| |
| <h3 id="invalid_lambda_function_call"><a href="sql-error-conditions-invalid-lambda-function-call-error-class.html">INVALID_LAMBDA_FUNCTION_CALL</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid lambda function call.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-lambda-function-call-error-class.html">INVALID_LAMBDA_FUNCTION_CALL</a></p> |
| |
| <h3 id="invalid_lateral_join_type">INVALID_LATERAL_JOIN_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42613</a></p> |
| |
| <p>The <code class="language-plaintext highlighter-rouge"><joinType></code> JOIN with LATERAL correlation is not allowed because an OUTER subquery cannot correlate to its join partner. Remove the LATERAL correlation or use an INNER JOIN, or LEFT OUTER JOIN instead.</p> |
| |
| <h3 id="invalid_limit_like_expression"><a href="sql-error-conditions-invalid-limit-like-expression-error-class.html">INVALID_LIMIT_LIKE_EXPRESSION</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The limit like expression <code class="language-plaintext highlighter-rouge"><expr></code> is invalid.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-limit-like-expression-error-class.html">INVALID_LIMIT_LIKE_EXPRESSION</a></p> |
| |
| <h3 id="invalid_non_deterministic_expressions">INVALID_NON_DETERMINISTIC_EXPRESSIONS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The operator expects a deterministic expression, but the actual expression is <code class="language-plaintext highlighter-rouge"><sqlExprs></code>.</p> |
| |
| <h3 id="invalid_numeric_literal_range">INVALID_NUMERIC_LITERAL_RANGE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Numeric literal <code class="language-plaintext highlighter-rouge"><rawStrippedQualifier></code> is outside the valid range for <code class="language-plaintext highlighter-rouge"><typeName></code> with minimum value of <code class="language-plaintext highlighter-rouge"><minValue></code> and maximum value of <code class="language-plaintext highlighter-rouge"><maxValue></code>. Please adjust the value accordingly.</p> |
| |
| <h3 id="invalid_observed_metrics"><a href="sql-error-conditions-invalid-observed-metrics-error-class.html">INVALID_OBSERVED_METRICS</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Invalid observed metrics.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-observed-metrics-error-class.html">INVALID_OBSERVED_METRICS</a></p> |
| |
| <h3 id="invalid_options"><a href="sql-error-conditions-invalid-options-error-class.html">INVALID_OPTIONS</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K06</a></p> |
| |
| <p>Invalid options:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-options-error-class.html">INVALID_OPTIONS</a></p> |
| |
| <h3 id="invalid_pandas_udf_placement">INVALID_PANDAS_UDF_PLACEMENT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>The group aggregate pandas UDF <code class="language-plaintext highlighter-rouge"><functionList></code> cannot be invoked together with as other, non-pandas aggregate functions.</p> |
| |
| <h3 id="invalid_parameter_value"><a href="sql-error-conditions-invalid-parameter-value-error-class.html">INVALID_PARAMETER_VALUE</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22023</a></p> |
| |
| <p>The value of parameter(s) <code class="language-plaintext highlighter-rouge"><parameter></code> in <code class="language-plaintext highlighter-rouge"><functionName></code> is invalid:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-parameter-value-error-class.html">INVALID_PARAMETER_VALUE</a></p> |
| |
| <h3 id="invalid_partition_operation"><a href="sql-error-conditions-invalid-partition-operation-error-class.html">INVALID_PARTITION_OPERATION</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The partition command is invalid.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-partition-operation-error-class.html">INVALID_PARTITION_OPERATION</a></p> |
| |
| <h3 id="invalid_property_key">INVALID_PROPERTY_KEY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42602</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><key></code> is an invalid property key, please use quotes, e.g. SET <code class="language-plaintext highlighter-rouge"><key></code>=<code class="language-plaintext highlighter-rouge"><value></code>.</p> |
| |
| <h3 id="invalid_property_value">INVALID_PROPERTY_VALUE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42602</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><value></code> is an invalid property value, please use quotes, e.g. SET <code class="language-plaintext highlighter-rouge"><key></code>=<code class="language-plaintext highlighter-rouge"><value></code></p> |
| |
| <h3 id="invalid_schema"><a href="sql-error-conditions-invalid-schema-error-class.html">INVALID_SCHEMA</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K07</a></p> |
| |
| <p>The input schema <code class="language-plaintext highlighter-rouge"><inputSchema></code> is not a valid schema string.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-schema-error-class.html">INVALID_SCHEMA</a></p> |
| |
| <h3 id="invalid_set_syntax">INVALID_SET_SYNTAX</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Expected format is ‘SET’, ‘SET key’, or ‘SET key=value’. If you want to include special characters in key, or include semicolon in value, please use backquotes, e.g., SET <code class="language-plaintext highlighter-rouge">key</code>=<code class="language-plaintext highlighter-rouge">value</code>.</p> |
| |
| <h3 id="invalid_sql_arg">INVALID_SQL_ARG</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The argument <code class="language-plaintext highlighter-rouge"><name></code> of <code class="language-plaintext highlighter-rouge">sql()</code> is invalid. Consider to replace it by a SQL literal.</p> |
| |
| <h3 id="invalid_sql_syntax"><a href="sql-error-conditions-invalid-sql-syntax-error-class.html">INVALID_SQL_SYNTAX</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Invalid SQL syntax:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-sql-syntax-error-class.html">INVALID_SQL_SYNTAX</a></p> |
| |
| <h3 id="invalid_subquery_expression"><a href="sql-error-conditions-invalid-subquery-expression-error-class.html">INVALID_SUBQUERY_EXPRESSION</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42823</a></p> |
| |
| <p>Invalid subquery:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-subquery-expression-error-class.html">INVALID_SUBQUERY_EXPRESSION</a></p> |
| |
| <h3 id="invalid_temp_obj_reference">INVALID_TEMP_OBJ_REFERENCE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot create the persistent object <code class="language-plaintext highlighter-rouge"><objName></code> of the type <code class="language-plaintext highlighter-rouge"><obj></code> because it references to the temporary object <code class="language-plaintext highlighter-rouge"><tempObjName></code> of the type <code class="language-plaintext highlighter-rouge"><tempObj></code>. Please make the temporary object <code class="language-plaintext highlighter-rouge"><tempObjName></code> persistent, or make the persistent object <code class="language-plaintext highlighter-rouge"><objName></code> temporary.</p> |
| |
| <h3 id="invalid_time_travel_timestamp_expr"><a href="sql-error-conditions-invalid-time-travel-timestamp-expr-error-class.html">INVALID_TIME_TRAVEL_TIMESTAMP_EXPR</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The time travel timestamp expression <code class="language-plaintext highlighter-rouge"><expr></code> is invalid.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-time-travel-timestamp-expr-error-class.html">INVALID_TIME_TRAVEL_TIMESTAMP_EXPR</a></p> |
| |
| <h3 id="invalid_typed_literal">INVALID_TYPED_LITERAL</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42604</a></p> |
| |
| <p>The value of the typed literal <code class="language-plaintext highlighter-rouge"><valueType></code> is invalid: <code class="language-plaintext highlighter-rouge"><value></code>.</p> |
| |
| <h3 id="invalid_udf_implementation">INVALID_UDF_IMPLEMENTATION</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Function <code class="language-plaintext highlighter-rouge"><funcName></code> does not implement ScalarFunction or AggregateFunction.</p> |
| |
| <h3 id="invalid_url">INVALID_URL</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The url is invalid: <code class="language-plaintext highlighter-rouge"><url></code>. If necessary set <code class="language-plaintext highlighter-rouge"><ansiConfig></code> to “false” to bypass this error.</p> |
| |
| <h3 id="invalid_usage_of_star_or_regex">INVALID_USAGE_OF_STAR_OR_REGEX</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Invalid usage of <code class="language-plaintext highlighter-rouge"><elem></code> in <code class="language-plaintext highlighter-rouge"><prettyName></code>.</p> |
| |
| <h3 id="invalid_view_text">INVALID_VIEW_TEXT</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The view <code class="language-plaintext highlighter-rouge"><viewName></code> cannot be displayed due to invalid view text: <code class="language-plaintext highlighter-rouge"><viewText></code>. This may be caused by an unauthorized modification of the view or an incorrect query syntax. Please check your query syntax and verify that the view has not been tampered with.</p> |
| |
| <h3 id="invalid_where_condition">INVALID_WHERE_CONDITION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42903</a></p> |
| |
| <p>The WHERE condition <code class="language-plaintext highlighter-rouge"><condition></code> contains invalid expressions: <code class="language-plaintext highlighter-rouge"><expressionList></code>. |
| Rewrite the query to avoid window functions, aggregate functions, and generator functions in the WHERE clause.</p> |
| |
| <h3 id="invalid_window_spec_for_aggregation_func">INVALID_WINDOW_SPEC_FOR_AGGREGATION_FUNC</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot specify ORDER BY or a window frame for <code class="language-plaintext highlighter-rouge"><aggFunc></code>.</p> |
| |
| <h3 id="invalid_write_distribution"><a href="sql-error-conditions-invalid-write-distribution-error-class.html">INVALID_WRITE_DISTRIBUTION</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The requested write distribution is invalid.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-invalid-write-distribution-error-class.html">INVALID_WRITE_DISTRIBUTION</a></p> |
| |
| <h3 id="join_condition_is_not_boolean_type">JOIN_CONDITION_IS_NOT_BOOLEAN_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The join condition <code class="language-plaintext highlighter-rouge"><joinCondition></code> has the invalid type <code class="language-plaintext highlighter-rouge"><conditionType></code>, expected “BOOLEAN”.</p> |
| |
| <h3 id="load_data_path_not_exists">LOAD_DATA_PATH_NOT_EXISTS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>LOAD DATA input path does not exist: <code class="language-plaintext highlighter-rouge"><path></code>.</p> |
| |
| <h3 id="local_must_with_schema_file">LOCAL_MUST_WITH_SCHEMA_FILE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>LOCAL must be used together with the schema of <code class="language-plaintext highlighter-rouge">file</code>, but got: <code class="language-plaintext highlighter-rouge"><actualSchema></code>.</p> |
| |
| <h3 id="location_already_exists">LOCATION_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42710</a></p> |
| |
| <p>Cannot name the managed table as <code class="language-plaintext highlighter-rouge"><identifier></code>, as its associated location <code class="language-plaintext highlighter-rouge"><location></code> already exists. Please pick a different table name, or remove the existing location first.</p> |
| |
| <h3 id="malformed_csv_record">MALFORMED_CSV_RECORD</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Malformed CSV record: <code class="language-plaintext highlighter-rouge"><badRecord></code></p> |
| |
| <h3 id="malformed_protobuf_message">MALFORMED_PROTOBUF_MESSAGE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Malformed Protobuf messages are detected in message deserialization. Parse Mode: <code class="language-plaintext highlighter-rouge"><failFastMode></code>. To process malformed protobuf message as null result, try setting the option ‘mode’ as ‘PERMISSIVE’.</p> |
| |
| <h3 id="malformed_record_in_parsing"><a href="sql-error-conditions-malformed-record-in-parsing-error-class.html">MALFORMED_RECORD_IN_PARSING</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22023</a></p> |
| |
| <p>Malformed records are detected in record parsing: <code class="language-plaintext highlighter-rouge"><badRecord></code>. |
| Parse Mode: <code class="language-plaintext highlighter-rouge"><failFastMode></code>. To process malformed records as null result, try setting the option ‘mode’ as ‘PERMISSIVE’.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-malformed-record-in-parsing-error-class.html">MALFORMED_RECORD_IN_PARSING</a></p> |
| |
| <h3 id="merge_cardinality_violation">MERGE_CARDINALITY_VIOLATION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-23-integrity-constraint-violation">SQLSTATE: 23K01</a></p> |
| |
| <p>The ON search condition of the MERGE statement matched a single row from the target table with multiple rows of the source table. |
| This could result in the target row being operated on more than once with an update or delete operation and is not allowed.</p> |
| |
| <h3 id="missing_aggregation">MISSING_AGGREGATION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42803</a></p> |
| |
| <p>The non-aggregating expression <code class="language-plaintext highlighter-rouge"><expression></code> is based on columns which are not participating in the GROUP BY clause. |
| Add the columns or the expression to the GROUP BY, aggregate the expression, or use <code class="language-plaintext highlighter-rouge"><expressionAnyValue></code> if you do not care which of the values within a group is returned.</p> |
| |
| <h3 id="missing_attributes"><a href="sql-error-conditions-missing-attributes-error-class.html">MISSING_ATTRIBUTES</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Resolved attribute(s) <code class="language-plaintext highlighter-rouge"><missingAttributes></code> missing from <code class="language-plaintext highlighter-rouge"><input></code> in operator <code class="language-plaintext highlighter-rouge"><operator></code>.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-missing-attributes-error-class.html">MISSING_ATTRIBUTES</a></p> |
| |
| <h3 id="missing_group_by">MISSING_GROUP_BY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42803</a></p> |
| |
| <p>The query does not include a GROUP BY clause. Add GROUP BY or turn it into the window functions using OVER clauses.</p> |
| |
| <h3 id="multi_sources_unsupported_for_expression">MULTI_SOURCES_UNSUPPORTED_FOR_EXPRESSION</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The expression <code class="language-plaintext highlighter-rouge"><expr></code> does not support more than one source.</p> |
| |
| <h3 id="multi_udf_interface_error">MULTI_UDF_INTERFACE_ERROR</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Not allowed to implement multiple UDF interfaces, UDF class <code class="language-plaintext highlighter-rouge"><className></code>.</p> |
| |
| <h3 id="named_parameters_not_supported">NAMED_PARAMETERS_NOT_SUPPORTED</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 4274K</a></p> |
| |
| <p>Named parameters are not supported for function <code class="language-plaintext highlighter-rouge"><functionName></code>; please retry the query with positional arguments to the function call instead.</p> |
| |
| <h3 id="named_parameter_support_disabled">NAMED_PARAMETER_SUPPORT_DISABLED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot call function <code class="language-plaintext highlighter-rouge"><functionName></code> because named argument references are not enabled here. In this case, the named argument reference was <code class="language-plaintext highlighter-rouge"><argument></code>. Set “spark.sql.allowNamedFunctionArguments” to “true” to turn on feature.</p> |
| |
| <h3 id="nested_aggregate_function">NESTED_AGGREGATE_FUNCTION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42607</a></p> |
| |
| <p>It is not allowed to use an aggregate function in the argument of another aggregate function. Please use the inner aggregate function in a sub-query.</p> |
| |
| <h3 id="non_last_matched_clause_omit_condition">NON_LAST_MATCHED_CLAUSE_OMIT_CONDITION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42613</a></p> |
| |
| <p>When there are more than one MATCHED clauses in a MERGE statement, only the last MATCHED clause can omit the condition.</p> |
| |
| <h3 id="non_last_not_matched_by_source_clause_omit_condition">NON_LAST_NOT_MATCHED_BY_SOURCE_CLAUSE_OMIT_CONDITION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42613</a></p> |
| |
| <p>When there are more than one NOT MATCHED BY SOURCE clauses in a MERGE statement, only the last NOT MATCHED BY SOURCE clause can omit the condition.</p> |
| |
| <h3 id="non_last_not_matched_by_target_clause_omit_condition">NON_LAST_NOT_MATCHED_BY_TARGET_CLAUSE_OMIT_CONDITION</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42613</a></p> |
| |
| <p>When there are more than one NOT MATCHED [BY TARGET] clauses in a MERGE statement, only the last NOT MATCHED [BY TARGET] clause can omit the condition.</p> |
| |
| <h3 id="non_literal_pivot_values">NON_LITERAL_PIVOT_VALUES</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K08</a></p> |
| |
| <p>Literal expressions required for pivot values, found <code class="language-plaintext highlighter-rouge"><expression></code>.</p> |
| |
| <h3 id="non_partition_column">NON_PARTITION_COLUMN</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>PARTITION clause cannot contain the non-partition column: <code class="language-plaintext highlighter-rouge"><columnName></code>.</p> |
| |
| <h3 id="non_time_window_not_supported_in_streaming">NON_TIME_WINDOW_NOT_SUPPORTED_IN_STREAMING</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Window function is not supported in <code class="language-plaintext highlighter-rouge"><windowFunc></code> (as column <code class="language-plaintext highlighter-rouge"><columnName></code>) on streaming DataFrames/Datasets. Structured Streaming only supports time-window aggregation using the WINDOW function. (window specification: <code class="language-plaintext highlighter-rouge"><windowSpec></code>)</p> |
| |
| <h3 id="not_allowed_in_from"><a href="sql-error-conditions-not-allowed-in-from-error-class.html">NOT_ALLOWED_IN_FROM</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Not allowed in the FROM clause:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-not-allowed-in-from-error-class.html">NOT_ALLOWED_IN_FROM</a></p> |
| |
| <h3 id="not_a_constant_string"><a href="sql-error-conditions-not-a-constant-string-error-class.html">NOT_A_CONSTANT_STRING</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42601</a></p> |
| |
| <p>The expression <code class="language-plaintext highlighter-rouge"><expr></code> used for the routine or clause <code class="language-plaintext highlighter-rouge"><name></code> must be a constant STRING which is NOT NULL.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-not-a-constant-string-error-class.html">NOT_A_CONSTANT_STRING</a></p> |
| |
| <h3 id="not_a_partitioned_table">NOT_A_PARTITIONED_TABLE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Operation <code class="language-plaintext highlighter-rouge"><operation></code> is not allowed for <code class="language-plaintext highlighter-rouge"><tableIdentWithDB></code> because it is not a partitioned table.</p> |
| |
| <h3 id="not_null_constraint_violation"><a href="sql-error-conditions-not-null-constraint-violation-error-class.html">NOT_NULL_CONSTRAINT_VIOLATION</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Assigning a NULL is not allowed here.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-not-null-constraint-violation-error-class.html">NOT_NULL_CONSTRAINT_VIOLATION</a></p> |
| |
| <h3 id="not_supported_change_column">NOT_SUPPORTED_CHANGE_COLUMN</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>ALTER TABLE ALTER/CHANGE COLUMN is not supported for changing <code class="language-plaintext highlighter-rouge"><table></code>’s column <code class="language-plaintext highlighter-rouge"><originName></code> with type <code class="language-plaintext highlighter-rouge"><originType></code> to <code class="language-plaintext highlighter-rouge"><newName></code> with type <code class="language-plaintext highlighter-rouge"><newType></code>.</p> |
| |
| <h3 id="not_supported_command_for_v2_table">NOT_SUPPORTED_COMMAND_FOR_V2_TABLE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-46-java-ddl-1">SQLSTATE: 46110</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><cmd></code> is not supported for v2 tables.</p> |
| |
| <h3 id="not_supported_command_without_hive_support">NOT_SUPPORTED_COMMAND_WITHOUT_HIVE_SUPPORT</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><cmd></code> is not supported, if you want to enable it, please set “spark.sql.catalogImplementation” to “hive”.</p> |
| |
| <h3 id="not_supported_in_jdbc_catalog"><a href="sql-error-conditions-not-supported-in-jdbc-catalog-error-class.html">NOT_SUPPORTED_IN_JDBC_CATALOG</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-46-java-ddl-1">SQLSTATE: 46110</a></p> |
| |
| <p>Not supported command in JDBC catalog:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-not-supported-in-jdbc-catalog-error-class.html">NOT_SUPPORTED_IN_JDBC_CATALOG</a></p> |
| |
| <h3 id="no_default_column_value_available">NO_DEFAULT_COLUMN_VALUE_AVAILABLE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42608</a></p> |
| |
| <p>Can’t determine the default value for <code class="language-plaintext highlighter-rouge"><colName></code> since it is not nullable and it has no default value.</p> |
| |
| <h3 id="no_handler_for_udaf">NO_HANDLER_FOR_UDAF</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>No handler for UDAF ‘<code class="language-plaintext highlighter-rouge"><functionName></code>’. Use sparkSession.udf.register(…) instead.</p> |
| |
| <h3 id="no_sql_type_in_protobuf_schema">NO_SQL_TYPE_IN_PROTOBUF_SCHEMA</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot find <code class="language-plaintext highlighter-rouge"><catalystFieldPath></code> in Protobuf schema.</p> |
| |
| <h3 id="no_udf_interface">NO_UDF_INTERFACE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>UDF class <code class="language-plaintext highlighter-rouge"><className></code> doesn’t implement any UDF interface.</p> |
| |
| <h3 id="nullable_column_or_field">NULLABLE_COLUMN_OR_FIELD</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Column or field <code class="language-plaintext highlighter-rouge"><name></code> is nullable while it’s required to be non-nullable.</p> |
| |
| <h3 id="nullable_row_id_attributes">NULLABLE_ROW_ID_ATTRIBUTES</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42000</a></p> |
| |
| <p>Row ID attributes cannot be nullable: <code class="language-plaintext highlighter-rouge"><nullableRowIdAttrs></code>.</p> |
| |
| <h3 id="null_map_key">NULL_MAP_KEY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 2200E</a></p> |
| |
| <p>Cannot use null as map key.</p> |
| |
| <h3 id="numeric_out_of_supported_range">NUMERIC_OUT_OF_SUPPORTED_RANGE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p>The value <code class="language-plaintext highlighter-rouge"><value></code> cannot be interpreted as a numeric since it has more than 38 digits.</p> |
| |
| <h3 id="numeric_value_out_of_range">NUMERIC_VALUE_OUT_OF_RANGE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22003</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><value></code> cannot be represented as Decimal(<code class="language-plaintext highlighter-rouge"><precision></code>, <code class="language-plaintext highlighter-rouge"><scale></code>). If necessary set <code class="language-plaintext highlighter-rouge"><config></code> to “false” to bypass this error, and return NULL instead.</p> |
| |
| <h3 id="num_columns_mismatch">NUM_COLUMNS_MISMATCH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42826</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><operator></code> can only be performed on inputs with the same number of columns, but the first input has <code class="language-plaintext highlighter-rouge"><firstNumColumns></code> columns and the <code class="language-plaintext highlighter-rouge"><invalidOrdinalNum></code> input has <code class="language-plaintext highlighter-rouge"><invalidNumColumns></code> columns.</p> |
| |
| <h3 id="num_table_value_aliases_mismatch">NUM_TABLE_VALUE_ALIASES_MISMATCH</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Number of given aliases does not match number of output columns. Function name: <code class="language-plaintext highlighter-rouge"><funcName></code>; number of aliases: <code class="language-plaintext highlighter-rouge"><aliasesNum></code>; number of output columns: <code class="language-plaintext highlighter-rouge"><outColsNum></code>.</p> |
| |
| <h3 id="operation_canceled">OPERATION_CANCELED</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-HY-cli-specific-condition">SQLSTATE: HY008</a></p> |
| |
| <p>Operation has been canceled.</p> |
| |
| <h3 id="order_by_pos_out_of_range">ORDER_BY_POS_OUT_OF_RANGE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42805</a></p> |
| |
| <p>ORDER BY position <code class="language-plaintext highlighter-rouge"><index></code> is not in select list (valid range is [1, <code class="language-plaintext highlighter-rouge"><size></code>]).</p> |
| |
| <h3 id="parse_empty_statement">PARSE_EMPTY_STATEMENT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42617</a></p> |
| |
| <p>Syntax error, unexpected empty statement.</p> |
| |
| <h3 id="parse_syntax_error">PARSE_SYNTAX_ERROR</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42601</a></p> |
| |
| <p>Syntax error at or near <code class="language-plaintext highlighter-rouge"><error></code><code class="language-plaintext highlighter-rouge"><hint></code>.</p> |
| |
| <h3 id="partitions_already_exist">PARTITIONS_ALREADY_EXIST</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 428FT</a></p> |
| |
| <p>Cannot ADD or RENAME TO partition(s) <code class="language-plaintext highlighter-rouge"><partitionList></code> in table <code class="language-plaintext highlighter-rouge"><tableName></code> because they already exist. |
| Choose a different name, drop the existing partition, or add the IF NOT EXISTS clause to tolerate a pre-existing partition.</p> |
| |
| <h3 id="partitions_not_found">PARTITIONS_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 428FT</a></p> |
| |
| <p>The partition(s) <code class="language-plaintext highlighter-rouge"><partitionList></code> cannot be found in table <code class="language-plaintext highlighter-rouge"><tableName></code>. |
| Verify the partition specification and table name. |
| To tolerate the error on drop use ALTER TABLE … DROP IF EXISTS PARTITION.</p> |
| |
| <h3 id="path_already_exists">PATH_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K04</a></p> |
| |
| <p>Path <code class="language-plaintext highlighter-rouge"><outputPath></code> already exists. Set mode as “overwrite” to overwrite the existing path.</p> |
| |
| <h3 id="path_not_found">PATH_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K03</a></p> |
| |
| <p>Path does not exist: <code class="language-plaintext highlighter-rouge"><path></code>.</p> |
| |
| <h3 id="pivot_value_data_type_mismatch">PIVOT_VALUE_DATA_TYPE_MISMATCH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K09</a></p> |
| |
| <p>Invalid pivot value ‘<code class="language-plaintext highlighter-rouge"><value></code>’: value data type <code class="language-plaintext highlighter-rouge"><valueType></code> does not match pivot column data type <code class="language-plaintext highlighter-rouge"><pivotType></code>.</p> |
| |
| <h3 id="plan_validation_failed_rule_executor">PLAN_VALIDATION_FAILED_RULE_EXECUTOR</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The input plan of <code class="language-plaintext highlighter-rouge"><ruleExecutor></code> is invalid: <code class="language-plaintext highlighter-rouge"><reason></code></p> |
| |
| <h3 id="plan_validation_failed_rule_in_batch">PLAN_VALIDATION_FAILED_RULE_IN_BATCH</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Rule <code class="language-plaintext highlighter-rouge"><rule></code> in batch <code class="language-plaintext highlighter-rouge"><batch></code> generated an invalid plan: <code class="language-plaintext highlighter-rouge"><reason></code></p> |
| |
| <h3 id="protobuf_dependency_not_found">PROTOBUF_DEPENDENCY_NOT_FOUND</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Could not find dependency: <code class="language-plaintext highlighter-rouge"><dependencyName></code>.</p> |
| |
| <h3 id="protobuf_descriptor_file_not_found">PROTOBUF_DESCRIPTOR_FILE_NOT_FOUND</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Error reading Protobuf descriptor file at path: <code class="language-plaintext highlighter-rouge"><filePath></code>.</p> |
| |
| <h3 id="protobuf_field_missing">PROTOBUF_FIELD_MISSING</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Searching for <code class="language-plaintext highlighter-rouge"><field></code> in Protobuf schema at <code class="language-plaintext highlighter-rouge"><protobufSchema></code> gave <code class="language-plaintext highlighter-rouge"><matchSize></code> matches. Candidates: <code class="language-plaintext highlighter-rouge"><matches></code>.</p> |
| |
| <h3 id="protobuf_field_missing_in_sql_schema">PROTOBUF_FIELD_MISSING_IN_SQL_SCHEMA</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Found <code class="language-plaintext highlighter-rouge"><field></code> in Protobuf schema but there is no match in the SQL schema.</p> |
| |
| <h3 id="protobuf_field_type_mismatch">PROTOBUF_FIELD_TYPE_MISMATCH</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Type mismatch encountered for field: <code class="language-plaintext highlighter-rouge"><field></code>.</p> |
| |
| <h3 id="protobuf_message_not_found">PROTOBUF_MESSAGE_NOT_FOUND</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Unable to locate Message <code class="language-plaintext highlighter-rouge"><messageName></code> in Descriptor.</p> |
| |
| <h3 id="protobuf_type_not_support">PROTOBUF_TYPE_NOT_SUPPORT</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Protobuf type not yet supported: <code class="language-plaintext highlighter-rouge"><protobufType></code>.</p> |
| |
| <h3 id="recursive_protobuf_schema">RECURSIVE_PROTOBUF_SCHEMA</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Found recursive reference in Protobuf schema, which can not be processed by Spark by default: <code class="language-plaintext highlighter-rouge"><fieldDescriptor></code>. try setting the option <code class="language-plaintext highlighter-rouge">recursive.fields.max.depth</code> 0 to 10. Going beyond 10 levels of recursion is not allowed.</p> |
| |
| <h3 id="recursive_view">RECURSIVE_VIEW</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Recursive view <code class="language-plaintext highlighter-rouge"><viewIdent></code> detected (cycle: <code class="language-plaintext highlighter-rouge"><newPath></code>).</p> |
| |
| <h3 id="ref_default_value_is_not_allowed_in_partition">REF_DEFAULT_VALUE_IS_NOT_ALLOWED_IN_PARTITION</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>References to DEFAULT column values are not allowed within the PARTITION clause.</p> |
| |
| <h3 id="rename_src_path_not_found">RENAME_SRC_PATH_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K03</a></p> |
| |
| <p>Failed to rename as <code class="language-plaintext highlighter-rouge"><sourcePath></code> was not found.</p> |
| |
| <h3 id="repeated_clause">REPEATED_CLAUSE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42614</a></p> |
| |
| <p>The <code class="language-plaintext highlighter-rouge"><clause></code> clause may be used at most once per <code class="language-plaintext highlighter-rouge"><operation></code> operation.</p> |
| |
| <h3 id="required_parameter_not_found">REQUIRED_PARAMETER_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 4274K</a></p> |
| |
| <p>Cannot invoke function <code class="language-plaintext highlighter-rouge"><functionName></code> because the parameter named <code class="language-plaintext highlighter-rouge"><parameterName></code> is required, but the function call did not supply a value. Please update the function call to supply an argument value (either positionally at index <code class="language-plaintext highlighter-rouge"><index></code> or by name) and retry the query again.</p> |
| |
| <h3 id="requires_single_part_namespace">REQUIRES_SINGLE_PART_NAMESPACE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K05</a></p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><sessionCatalog></code> requires a single-part namespace, but got <code class="language-plaintext highlighter-rouge"><namespace></code>.</p> |
| |
| <h3 id="routine_already_exists">ROUTINE_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42723</a></p> |
| |
| <p>Cannot create the function <code class="language-plaintext highlighter-rouge"><routineName></code> because it already exists. |
| Choose a different name, drop or replace the existing function, or add the IF NOT EXISTS clause to tolerate a pre-existing function.</p> |
| |
| <h3 id="routine_not_found">ROUTINE_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42883</a></p> |
| |
| <p>The function <code class="language-plaintext highlighter-rouge"><routineName></code> cannot be found. Verify the spelling and correctness of the schema and catalog. |
| If you did not qualify the name with a schema and catalog, verify the current_schema() output, or qualify the name with the correct schema and catalog. |
| To tolerate the error on drop use DROP FUNCTION IF EXISTS.</p> |
| |
| <h3 id="rule_id_not_found">RULE_ID_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22023</a></p> |
| |
| <p>Not found an id for the rule name “<code class="language-plaintext highlighter-rouge"><ruleName></code>”. Please modify RuleIdCollection.scala if you are adding a new rule.</p> |
| |
| <h3 id="scalar_subquery_is_in_group_by_or_aggregate_function">SCALAR_SUBQUERY_IS_IN_GROUP_BY_OR_AGGREGATE_FUNCTION</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The correlated scalar subquery ‘<code class="language-plaintext highlighter-rouge"><sqlExpr></code>’ is neither present in GROUP BY, nor in an aggregate function. Add it to GROUP BY using ordinal position or wrap it in <code class="language-plaintext highlighter-rouge">first()</code> (or <code class="language-plaintext highlighter-rouge">first_value</code>) if you don’t care which value you get.</p> |
| |
| <h3 id="scalar_subquery_too_many_rows">SCALAR_SUBQUERY_TOO_MANY_ROWS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-21-cardinality-violation">SQLSTATE: 21000</a></p> |
| |
| <p>More than one row returned by a subquery used as an expression.</p> |
| |
| <h3 id="schema_already_exists">SCHEMA_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P06</a></p> |
| |
| <p>Cannot create schema <code class="language-plaintext highlighter-rouge"><schemaName></code> because it already exists. |
| Choose a different name, drop the existing schema, or add the IF NOT EXISTS clause to tolerate pre-existing schema.</p> |
| |
| <h3 id="schema_not_empty">SCHEMA_NOT_EMPTY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-2B-dependent-privilege-descriptors-still-exist">SQLSTATE: 2BP01</a></p> |
| |
| <p>Cannot drop a schema <code class="language-plaintext highlighter-rouge"><schemaName></code> because it contains objects. |
| Use DROP SCHEMA … CASCADE to drop the schema and all its objects.</p> |
| |
| <h3 id="schema_not_found">SCHEMA_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42704</a></p> |
| |
| <p>The schema <code class="language-plaintext highlighter-rouge"><schemaName></code> cannot be found. Verify the spelling and correctness of the schema and catalog. |
| If you did not qualify the name with a catalog, verify the current_schema() output, or qualify the name with the correct catalog. |
| To tolerate the error on drop use DROP SCHEMA IF EXISTS.</p> |
| |
| <h3 id="second_function_argument_not_integer">SECOND_FUNCTION_ARGUMENT_NOT_INTEGER</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-22-data-exception">SQLSTATE: 22023</a></p> |
| |
| <p>The second argument of <code class="language-plaintext highlighter-rouge"><functionName></code> function needs to be an integer.</p> |
| |
| <h3 id="seed_expression_is_unfoldable">SEED_EXPRESSION_IS_UNFOLDABLE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The seed expression <code class="language-plaintext highlighter-rouge"><seedExpr></code> of the expression <code class="language-plaintext highlighter-rouge"><exprWithSeed></code> must be foldable.</p> |
| |
| <h3 id="sort_by_without_bucketing">SORT_BY_WITHOUT_BUCKETING</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>sortBy must be used together with bucketBy.</p> |
| |
| <h3 id="specify_bucketing_is_not_allowed">SPECIFY_BUCKETING_IS_NOT_ALLOWED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot specify bucketing information if the table schema is not specified when creating and will be inferred at runtime.</p> |
| |
| <h3 id="specify_partition_is_not_allowed">SPECIFY_PARTITION_IS_NOT_ALLOWED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>It is not allowed to specify partition columns when the table schema is not defined. When the table schema is not provided, schema and partition columns will be inferred.</p> |
| |
| <h3 id="sql_conf_not_found">SQL_CONF_NOT_FOUND</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The SQL config <code class="language-plaintext highlighter-rouge"><sqlConf></code> cannot be found. Please verify that the config exists.</p> |
| |
| <h3 id="star_group_by_pos">STAR_GROUP_BY_POS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>Star (*) is not allowed in a select list when GROUP BY an ordinal position is used.</p> |
| |
| <h3 id="static_partition_column_in_insert_column_list">STATIC_PARTITION_COLUMN_IN_INSERT_COLUMN_LIST</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Static partition column <code class="language-plaintext highlighter-rouge"><staticName></code> is also specified in the column list.</p> |
| |
| <h3 id="stream_failed">STREAM_FAILED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Query [id = <code class="language-plaintext highlighter-rouge"><id></code>, runId = <code class="language-plaintext highlighter-rouge"><runId></code>] terminated with exception: <code class="language-plaintext highlighter-rouge"><message></code></p> |
| |
| <h3 id="sum_of_limit_and_offset_exceeds_max_int">SUM_OF_LIMIT_AND_OFFSET_EXCEEDS_MAX_INT</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The sum of the LIMIT clause and the OFFSET clause must not be greater than the maximum 32-bit integer value (2,147,483,647) but found limit = <code class="language-plaintext highlighter-rouge"><limit></code>, offset = <code class="language-plaintext highlighter-rouge"><offset></code>.</p> |
| |
| <h3 id="table_or_view_already_exists">TABLE_OR_VIEW_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P07</a></p> |
| |
| <p>Cannot create table or view <code class="language-plaintext highlighter-rouge"><relationName></code> because it already exists. |
| Choose a different name, drop or replace the existing object, or add the IF NOT EXISTS clause to tolerate pre-existing objects.</p> |
| |
| <h3 id="table_or_view_not_found">TABLE_OR_VIEW_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P01</a></p> |
| |
| <p>The table or view <code class="language-plaintext highlighter-rouge"><relationName></code> cannot be found. Verify the spelling and correctness of the schema and catalog. |
| If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog. |
| To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS.</p> |
| |
| <h3 id="table_valued_function_too_many_table_arguments">TABLE_VALUED_FUNCTION_TOO_MANY_TABLE_ARGUMENTS</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>There are too many table arguments for table-valued function. It allows one table argument, but got: <code class="language-plaintext highlighter-rouge"><num></code>. If you want to allow it, please set “spark.sql.allowMultipleTableArguments.enabled” to “true”</p> |
| |
| <h3 id="task_write_failed">TASK_WRITE_FAILED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Task failed while writing rows to <code class="language-plaintext highlighter-rouge"><path></code>.</p> |
| |
| <h3 id="temp_table_or_view_already_exists">TEMP_TABLE_OR_VIEW_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P07</a></p> |
| |
| <p>Cannot create the temporary view <code class="language-plaintext highlighter-rouge"><relationName></code> because it already exists. |
| Choose a different name, drop or replace the existing view, or add the IF NOT EXISTS clause to tolerate pre-existing views.</p> |
| |
| <h3 id="temp_view_name_too_many_name_parts">TEMP_VIEW_NAME_TOO_MANY_NAME_PARTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 428EK</a></p> |
| |
| <p>CREATE TEMPORARY VIEW or the corresponding Dataset APIs only accept single-part view names, but got: <code class="language-plaintext highlighter-rouge"><actualName></code>.</p> |
| |
| <h3 id="too_many_array_elements">TOO_MANY_ARRAY_ELEMENTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-54-program-limit-exceeded">SQLSTATE: 54000</a></p> |
| |
| <p>Cannot initialize array with <code class="language-plaintext highlighter-rouge"><numElements></code> elements of size <code class="language-plaintext highlighter-rouge"><size></code>.</p> |
| |
| <h3 id="udtf_alias_number_mismatch">UDTF_ALIAS_NUMBER_MISMATCH</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The number of aliases supplied in the AS clause does not match the number of columns output by the UDTF. Expected <code class="language-plaintext highlighter-rouge"><aliasesSize></code> aliases, but got <code class="language-plaintext highlighter-rouge"><aliasesNames></code>. Please ensure that the number of aliases provided matches the number of columns output by the UDTF.</p> |
| |
| <h3 id="unable_to_acquire_memory">UNABLE_TO_ACQUIRE_MEMORY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-53-insufficient-resources">SQLSTATE: 53200</a></p> |
| |
| <p>Unable to acquire <code class="language-plaintext highlighter-rouge"><requestedBytes></code> bytes of memory, got <code class="language-plaintext highlighter-rouge"><receivedBytes></code>.</p> |
| |
| <h3 id="unable_to_convert_to_protobuf_message_type">UNABLE_TO_CONVERT_TO_PROTOBUF_MESSAGE_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Unable to convert SQL type <code class="language-plaintext highlighter-rouge"><toType></code> to Protobuf type <code class="language-plaintext highlighter-rouge"><protobufType></code>.</p> |
| |
| <h3 id="unable_to_infer_schema">UNABLE_TO_INFER_SCHEMA</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42KD9</a></p> |
| |
| <p>Unable to infer schema for <code class="language-plaintext highlighter-rouge"><format></code>. It must be specified manually.</p> |
| |
| <h3 id="unbound_sql_parameter">UNBOUND_SQL_PARAMETER</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P02</a></p> |
| |
| <p>Found the unbound parameter: <code class="language-plaintext highlighter-rouge"><name></code>. Please, fix <code class="language-plaintext highlighter-rouge">args</code> and provide a mapping of the parameter to a SQL literal.</p> |
| |
| <h3 id="unclosed_bracketed_comment">UNCLOSED_BRACKETED_COMMENT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42601</a></p> |
| |
| <p>Found an unclosed bracketed comment. Please, append */ at the end of the comment.</p> |
| |
| <h3 id="unexpected_input_type">UNEXPECTED_INPUT_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K09</a></p> |
| |
| <p>Parameter <code class="language-plaintext highlighter-rouge"><paramIndex></code> of function <code class="language-plaintext highlighter-rouge"><functionName></code> requires the <code class="language-plaintext highlighter-rouge"><requiredType></code> type, however <code class="language-plaintext highlighter-rouge"><inputSql></code> has the type <code class="language-plaintext highlighter-rouge"><inputType></code>.</p> |
| |
| <h3 id="unexpected_positional_argument">UNEXPECTED_POSITIONAL_ARGUMENT</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 4274K</a></p> |
| |
| <p>Cannot invoke function <code class="language-plaintext highlighter-rouge"><functionName></code> because it contains positional argument(s) following the named argument assigned to <code class="language-plaintext highlighter-rouge"><parameterName></code>; please rearrange them so the positional arguments come first and then retry the query again.</p> |
| |
| <h3 id="unknown_protobuf_message_type">UNKNOWN_PROTOBUF_MESSAGE_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Attempting to treat <code class="language-plaintext highlighter-rouge"><descriptorName></code> as a Message, but it was <code class="language-plaintext highlighter-rouge"><containingType></code>.</p> |
| |
| <h3 id="unpivot_requires_attributes">UNPIVOT_REQUIRES_ATTRIBUTES</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K0A</a></p> |
| |
| <p>UNPIVOT requires all given <code class="language-plaintext highlighter-rouge"><given></code> expressions to be columns when no <code class="language-plaintext highlighter-rouge"><empty></code> expressions are given. These are not columns: [<code class="language-plaintext highlighter-rouge"><expressions></code>].</p> |
| |
| <h3 id="unpivot_requires_value_columns">UNPIVOT_REQUIRES_VALUE_COLUMNS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K0A</a></p> |
| |
| <p>At least one value column needs to be specified for UNPIVOT, all columns specified as ids.</p> |
| |
| <h3 id="unpivot_value_data_type_mismatch">UNPIVOT_VALUE_DATA_TYPE_MISMATCH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42K09</a></p> |
| |
| <p>Unpivot value columns must share a least common type, some types do not: [<code class="language-plaintext highlighter-rouge"><types></code>].</p> |
| |
| <h3 id="unpivot_value_size_mismatch">UNPIVOT_VALUE_SIZE_MISMATCH</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 428C4</a></p> |
| |
| <p>All unpivot value columns must have the same size as there are value column names (<code class="language-plaintext highlighter-rouge"><names></code>).</p> |
| |
| <h3 id="unrecognized_parameter_name">UNRECOGNIZED_PARAMETER_NAME</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 4274K</a></p> |
| |
| <p>Cannot invoke function <code class="language-plaintext highlighter-rouge"><functionName></code> because the function call included a named argument reference for the argument named <code class="language-plaintext highlighter-rouge"><argumentName></code>, but this function does not include any signature containing an argument with this name. Did you mean one of the following? [<code class="language-plaintext highlighter-rouge"><proposal></code>].</p> |
| |
| <h3 id="unrecognized_sql_type">UNRECOGNIZED_SQL_TYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42704</a></p> |
| |
| <p>Unrecognized SQL type - name: <code class="language-plaintext highlighter-rouge"><typeName></code>, id: <code class="language-plaintext highlighter-rouge"><jdbcType></code>.</p> |
| |
| <h3 id="unresolvable_table_valued_function">UNRESOLVABLE_TABLE_VALUED_FUNCTION</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Could not resolve <code class="language-plaintext highlighter-rouge"><name></code> to a table-valued function. Please make sure that <code class="language-plaintext highlighter-rouge"><name></code> is defined as a table-valued function and that all required parameters are provided correctly. If <code class="language-plaintext highlighter-rouge"><name></code> is not defined, please create the table-valued function before using it. For more information about defining table-valued functions, please refer to the Apache Spark documentation.</p> |
| |
| <h3 id="unresolved_all_in_group_by">UNRESOLVED_ALL_IN_GROUP_BY</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42803</a></p> |
| |
| <p>Cannot infer grouping columns for GROUP BY ALL based on the select clause. Please explicitly specify the grouping columns.</p> |
| |
| <h3 id="unresolved_column"><a href="sql-error-conditions-unresolved-column-error-class.html">UNRESOLVED_COLUMN</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42703</a></p> |
| |
| <p>A column or function parameter with name <code class="language-plaintext highlighter-rouge"><objectName></code> cannot be resolved.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unresolved-column-error-class.html">UNRESOLVED_COLUMN</a></p> |
| |
| <h3 id="unresolved_field"><a href="sql-error-conditions-unresolved-field-error-class.html">UNRESOLVED_FIELD</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42703</a></p> |
| |
| <p>A field with name <code class="language-plaintext highlighter-rouge"><fieldName></code> cannot be resolved with the struct-type column <code class="language-plaintext highlighter-rouge"><columnPath></code>.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unresolved-field-error-class.html">UNRESOLVED_FIELD</a></p> |
| |
| <h3 id="unresolved_map_key"><a href="sql-error-conditions-unresolved-map-key-error-class.html">UNRESOLVED_MAP_KEY</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42703</a></p> |
| |
| <p>Cannot resolve column <code class="language-plaintext highlighter-rouge"><objectName></code> as a map key. If the key is a string literal, add the single quotes ‘’ around it.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unresolved-map-key-error-class.html">UNRESOLVED_MAP_KEY</a></p> |
| |
| <h3 id="unresolved_routine">UNRESOLVED_ROUTINE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42883</a></p> |
| |
| <p>Cannot resolve function <code class="language-plaintext highlighter-rouge"><routineName></code> on search path <code class="language-plaintext highlighter-rouge"><searchPath></code>.</p> |
| |
| <h3 id="unresolved_using_column_for_join">UNRESOLVED_USING_COLUMN_FOR_JOIN</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42703</a></p> |
| |
| <p>USING column <code class="language-plaintext highlighter-rouge"><colName></code> cannot be resolved on the <code class="language-plaintext highlighter-rouge"><side></code> side of the join. The <code class="language-plaintext highlighter-rouge"><side></code>-side columns: [<code class="language-plaintext highlighter-rouge"><suggestion></code>].</p> |
| |
| <h3 id="unset_nonexistent_properties">UNSET_NONEXISTENT_PROPERTIES</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Attempted to unset non-existent properties [<code class="language-plaintext highlighter-rouge"><properties></code>] in table <code class="language-plaintext highlighter-rouge"><table></code>.</p> |
| |
| <h3 id="unsupported_add_file"><a href="sql-error-conditions-unsupported-add-file-error-class.html">UNSUPPORTED_ADD_FILE</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Don’t support add file.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-add-file-error-class.html">UNSUPPORTED_ADD_FILE</a></p> |
| |
| <h3 id="unsupported_arrowtype">UNSUPPORTED_ARROWTYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>Unsupported arrow type <code class="language-plaintext highlighter-rouge"><typeName></code>.</p> |
| |
| <h3 id="unsupported_char_or_varchar_as_string">UNSUPPORTED_CHAR_OR_VARCHAR_AS_STRING</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The char/varchar type can’t be used in the table schema. If you want Spark treat them as string type as same as Spark 3.0 and earlier, please set “spark.sql.legacy.charVarcharAsString” to “true”.</p> |
| |
| <h3 id="unsupported_datasource_for_direct_query">UNSUPPORTED_DATASOURCE_FOR_DIRECT_QUERY</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Unsupported data source type for direct query on files: <code class="language-plaintext highlighter-rouge"><dataSourceType></code></p> |
| |
| <h3 id="unsupported_datatype">UNSUPPORTED_DATATYPE</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>Unsupported data type <code class="language-plaintext highlighter-rouge"><typeName></code>.</p> |
| |
| <h3 id="unsupported_data_type_for_datasource">UNSUPPORTED_DATA_TYPE_FOR_DATASOURCE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The <code class="language-plaintext highlighter-rouge"><format></code> datasource doesn’t support the column <code class="language-plaintext highlighter-rouge"><columnName></code> of the type <code class="language-plaintext highlighter-rouge"><columnType></code>.</p> |
| |
| <h3 id="unsupported_default_value"><a href="sql-error-conditions-unsupported-default-value-error-class.html">UNSUPPORTED_DEFAULT_VALUE</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>DEFAULT column values is not supported.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-default-value-error-class.html">UNSUPPORTED_DEFAULT_VALUE</a></p> |
| |
| <h3 id="unsupported_deserializer"><a href="sql-error-conditions-unsupported-deserializer-error-class.html">UNSUPPORTED_DESERIALIZER</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>The deserializer is not supported:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-deserializer-error-class.html">UNSUPPORTED_DESERIALIZER</a></p> |
| |
| <h3 id="unsupported_expression_generated_column">UNSUPPORTED_EXPRESSION_GENERATED_COLUMN</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Cannot create generated column <code class="language-plaintext highlighter-rouge"><fieldName></code> with generation expression <code class="language-plaintext highlighter-rouge"><expressionStr></code> because <code class="language-plaintext highlighter-rouge"><reason></code>.</p> |
| |
| <h3 id="unsupported_expr_for_operator">UNSUPPORTED_EXPR_FOR_OPERATOR</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>A query operator contains one or more unsupported expressions. Consider to rewrite it to avoid window functions, aggregate functions, and generator functions in the WHERE clause. |
| Invalid expressions: [<code class="language-plaintext highlighter-rouge"><invalidExprSqls></code>]</p> |
| |
| <h3 id="unsupported_expr_for_window">UNSUPPORTED_EXPR_FOR_WINDOW</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P20</a></p> |
| |
| <p>Expression <code class="language-plaintext highlighter-rouge"><sqlExpr></code> not supported within a window function.</p> |
| |
| <h3 id="unsupported_feature"><a href="sql-error-conditions-unsupported-feature-error-class.html">UNSUPPORTED_FEATURE</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>The feature is not supported:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-feature-error-class.html">UNSUPPORTED_FEATURE</a></p> |
| |
| <h3 id="unsupported_generator"><a href="sql-error-conditions-unsupported-generator-error-class.html">UNSUPPORTED_GENERATOR</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>The generator is not supported:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-generator-error-class.html">UNSUPPORTED_GENERATOR</a></p> |
| |
| <h3 id="unsupported_grouping_expression">UNSUPPORTED_GROUPING_EXPRESSION</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>grouping()/grouping_id() can only be used with GroupingSets/Cube/Rollup.</p> |
| |
| <h3 id="unsupported_insert"><a href="sql-error-conditions-unsupported-insert-error-class.html">UNSUPPORTED_INSERT</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Can’t insert into the target.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-insert-error-class.html">UNSUPPORTED_INSERT</a></p> |
| |
| <h3 id="unsupported_merge_condition"><a href="sql-error-conditions-unsupported-merge-condition-error-class.html">UNSUPPORTED_MERGE_CONDITION</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>MERGE operation contains unsupported <code class="language-plaintext highlighter-rouge"><condName></code> condition.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-merge-condition-error-class.html">UNSUPPORTED_MERGE_CONDITION</a></p> |
| |
| <h3 id="unsupported_overwrite"><a href="sql-error-conditions-unsupported-overwrite-error-class.html">UNSUPPORTED_OVERWRITE</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Can’t overwrite the target that is also being read from.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-overwrite-error-class.html">UNSUPPORTED_OVERWRITE</a></p> |
| |
| <h3 id="unsupported_save_mode"><a href="sql-error-conditions-unsupported-save-mode-error-class.html">UNSUPPORTED_SAVE_MODE</a></h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The save mode <code class="language-plaintext highlighter-rouge"><saveMode></code> is not supported for:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-save-mode-error-class.html">UNSUPPORTED_SAVE_MODE</a></p> |
| |
| <h3 id="unsupported_subquery_expression_category"><a href="sql-error-conditions-unsupported-subquery-expression-category-error-class.html">UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>Unsupported subquery expression:</p> |
| |
| <p>For more details see <a href="sql-error-conditions-unsupported-subquery-expression-category-error-class.html">UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY</a></p> |
| |
| <h3 id="unsupported_typed_literal">UNSUPPORTED_TYPED_LITERAL</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-0A-feature-not-supported">SQLSTATE: 0A000</a></p> |
| |
| <p>Literals of the type <code class="language-plaintext highlighter-rouge"><unsupportedType></code> are not supported. Supported types are <code class="language-plaintext highlighter-rouge"><supportedTypes></code>.</p> |
| |
| <h3 id="untyped_scala_udf">UNTYPED_SCALA_UDF</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>You’re using untyped Scala UDF, which does not have the input type information. Spark may blindly pass null to the Scala closure with primitive-type argument, and the closure will see the default value of the Java type for the null argument, e.g. <code class="language-plaintext highlighter-rouge">udf((x: Int) => x, IntegerType)</code>, the result is 0 for null input. To get rid of this error, you could:</p> |
| <ol> |
| <li>use typed Scala UDF APIs(without return type parameter), e.g. <code class="language-plaintext highlighter-rouge">udf((x: Int) => x)</code>.</li> |
| <li>use Java UDF APIs, e.g. <code class="language-plaintext highlighter-rouge">udf(new UDF1[String, Integer] { override def call(s: String): Integer = s.length() }, IntegerType)</code>, if input types are all non primitive.</li> |
| <li>set “spark.sql.legacy.allowUntypedScalaUDF” to “true” and use this API with caution.</li> |
| </ol> |
| |
| <h3 id="view_already_exists">VIEW_ALREADY_EXISTS</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P07</a></p> |
| |
| <p>Cannot create view <code class="language-plaintext highlighter-rouge"><relationName></code> because it already exists. |
| Choose a different name, drop or replace the existing object, or add the IF NOT EXISTS clause to tolerate pre-existing objects.</p> |
| |
| <h3 id="view_not_found">VIEW_NOT_FOUND</h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42P01</a></p> |
| |
| <p>The view <code class="language-plaintext highlighter-rouge"><relationName></code> cannot be found. Verify the spelling and correctness of the schema and catalog. |
| If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog. |
| To tolerate the error on drop use DROP VIEW IF EXISTS.</p> |
| |
| <h3 id="window_function_and_frame_mismatch">WINDOW_FUNCTION_AND_FRAME_MISMATCH</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p><code class="language-plaintext highlighter-rouge"><funcName></code> function can only be evaluated in an ordered row-based window frame with a single offset: <code class="language-plaintext highlighter-rouge"><windowExpr></code>.</p> |
| |
| <h3 id="window_function_without_over_clause">WINDOW_FUNCTION_WITHOUT_OVER_CLAUSE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>Window function <code class="language-plaintext highlighter-rouge"><funcName></code> requires an OVER clause.</p> |
| |
| <h3 id="write_stream_not_allowed">WRITE_STREAM_NOT_ALLOWED</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p><code class="language-plaintext highlighter-rouge">writeStream</code> can be called only on streaming Dataset/DataFrame.</p> |
| |
| <h3 id="wrong_command_for_object_type">WRONG_COMMAND_FOR_OBJECT_TYPE</h3> |
| |
| <p>SQLSTATE: none assigned</p> |
| |
| <p>The operation <code class="language-plaintext highlighter-rouge"><operation></code> requires a <code class="language-plaintext highlighter-rouge"><requiredType></code>. But <code class="language-plaintext highlighter-rouge"><objectName></code> is a <code class="language-plaintext highlighter-rouge"><foundType></code>. Use <code class="language-plaintext highlighter-rouge"><alternative></code> instead.</p> |
| |
| <h3 id="wrong_num_args"><a href="sql-error-conditions-wrong-num-args-error-class.html">WRONG_NUM_ARGS</a></h3> |
| |
| <p><a href="sql-error-conditions-sqlstates.html#class-42-syntax-error-or-access-rule-violation">SQLSTATE: 42605</a></p> |
| |
| <p>The <code class="language-plaintext highlighter-rouge"><functionName></code> requires <code class="language-plaintext highlighter-rouge"><expectedNum></code> parameters but the actual number is <code class="language-plaintext highlighter-rouge"><actualNum></code>.</p> |
| |
| <p>For more details see <a href="sql-error-conditions-wrong-num-args-error-class.html">WRONG_NUM_ARGS</a></p> |
| |
| |
| </div> |
| |
| <!-- /container --> |
| </div> |
| |
| <script src="js/vendor/jquery-3.5.1.min.js"></script> |
| <script src="js/vendor/bootstrap.bundle.min.js"></script> |
| |
| <script src="js/vendor/anchor.min.js"></script> |
| <script src="js/main.js"></script> |
| |
| <script type="text/javascript" src="js/vendor/docsearch.min.js"></script> |
| <script type="text/javascript"> |
| // DocSearch is entirely free and automated. DocSearch is built in two parts: |
| // 1. a crawler which we run on our own infrastructure every 24 hours. It follows every link |
| // in your website and extract content from every page it traverses. It then pushes this |
| // content to an Algolia index. |
| // 2. a JavaScript snippet to be inserted in your website that will bind this Algolia index |
| // to your search input and display its results in a dropdown UI. If you want to find more |
| // details on how works DocSearch, check the docs of DocSearch. |
| docsearch({ |
| apiKey: 'd62f962a82bc9abb53471cb7b89da35e', |
| appId: 'RAI69RXRSK', |
| indexName: 'apache_spark', |
| inputSelector: '#docsearch-input', |
| enhancedSearchInput: true, |
| algoliaOptions: { |
| 'facetFilters': ["version:3.5.0"] |
| }, |
| debug: false // Set debug to true if you want to inspect the dropdown |
| }); |
| |
| </script> |
| |
| <!-- MathJax Section --> |
| <script type="text/x-mathjax-config"> |
| MathJax.Hub.Config({ |
| TeX: { equationNumbers: { autoNumber: "AMS" } } |
| }); |
| </script> |
| <script> |
| // Note that we load MathJax this way to work with local file (file://), HTTP and HTTPS. |
| // We could use "//cdn.mathjax...", but that won't support "file://". |
| (function(d, script) { |
| script = d.createElement('script'); |
| script.type = 'text/javascript'; |
| script.async = true; |
| script.onload = function(){ |
| MathJax.Hub.Config({ |
| tex2jax: { |
| inlineMath: [ ["$", "$"], ["\\\\(","\\\\)"] ], |
| displayMath: [ ["$$","$$"], ["\\[", "\\]"] ], |
| processEscapes: true, |
| skipTags: ['script', 'noscript', 'style', 'textarea', 'pre'] |
| } |
| }); |
| }; |
| script.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + |
| 'cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.1/MathJax.js' + |
| '?config=TeX-AMS-MML_HTMLorMML'; |
| d.getElementsByTagName('head')[0].appendChild(script); |
| }(document)); |
| </script> |
| </body> |
| </html> |
