ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tom Beerbower (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (AMBARI-12129) Views: Use VARCHAR for DataStore entity String fields
Date Wed, 24 Jun 2015 17:34:04 GMT

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

Tom Beerbower updated AMBARI-12129:
-----------------------------------
    Description: 
An earlier change to view DataStore entity String fields mapped to CLOB type does not work
well because CLOB types can not be part of a WHERE clause.

DataStore was meant to be a lightweight persistence mechanism for views so it should be okay
to impose reasonable limitations on the entities that it stores.

For view entity String types we will use VARCHAR and limit the length to 4000 characters.
 An exception will be thrown if a String that exceeds that length is submitted.


  was:View DataStore String fields can not be CLOBs since they can't be used in a WHERE clause.
 Use VARCHAR(4000) and limit the size of the entity fields.


> Views: Use VARCHAR for DataStore entity String fields
> -----------------------------------------------------
>
>                 Key: AMBARI-12129
>                 URL: https://issues.apache.org/jira/browse/AMBARI-12129
>             Project: Ambari
>          Issue Type: Bug
>            Reporter: Tom Beerbower
>            Assignee: Tom Beerbower
>             Fix For: 2.1.0
>
>
> An earlier change to view DataStore entity String fields mapped to CLOB type does not
work well because CLOB types can not be part of a WHERE clause.
> DataStore was meant to be a lightweight persistence mechanism for views so it should
be okay to impose reasonable limitations on the entities that it stores.
> For view entity String types we will use VARCHAR and limit the length to 4000 characters.
 An exception will be thrown if a String that exceeds that length is submitted.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message