[ 
https://issues.apache.org/jira/browse/SPARK-27943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

jiaan.geng updated SPARK-27943:
-------------------------------
    Description: 
Default constraint with column is ANSI standard.

Hive 3.0+ has supported default constraint 
ref:https://issues.apache.org/jira/browse/HIVE-18726

But Spark SQL implement this feature not yet.

Hive is widely used in production environments and is the standard in the field 
of big data in fact. But Hive exists many version used in production and the 
feature between each version are different.

Spark SQL need to implement default constraint, but there are two points to pay 
attention to in design:

One is Spark SQL should reduce coupling with Hive. 

Another is  default constraint could compatible with different versions of Hive.

 

  was:
Default constraint with column is ANSI standard.

Hive 3.0+ has supported default constraint 
ref:https://issues.apache.org/jira/browse/HIVE-18726

But Spark SQL implement this feature not yet.

Hive is widely used in production environments and is the standard in the field 
of big data in fact. But Hive exists many version used in production and the 
feature between each version are different.

Spark SQL need to implement 


> Implement default constraint with Column for Hive table
> -------------------------------------------------------
>
>                 Key: SPARK-27943
>                 URL: https://issues.apache.org/jira/browse/SPARK-27943
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 2.3.0, 2.4.0
>            Reporter: jiaan.geng
>            Priority: Major
>
> Default constraint with column is ANSI standard.
> Hive 3.0+ has supported default constraint 
> ref:https://issues.apache.org/jira/browse/HIVE-18726
> But Spark SQL implement this feature not yet.
> Hive is widely used in production environments and is the standard in the 
> field of big data in fact. But Hive exists many version used in production 
> and the feature between each version are different.
> Spark SQL need to implement default constraint, but there are two points to 
> pay attention to in design:
> One is Spark SQL should reduce coupling with Hive. 
> Another is  default constraint could compatible with different versions of 
> Hive.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to