[ 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)