[
https://issues.apache.org/jira/browse/TRAFODION-2146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15412266#comment-15412266
]
Sandhya Sundaresan commented on TRAFODION-2146:
-----------------------------------------------
I think the preferred default is to allow the user to specify these at install
time. The reason is, installer can ensure Trafodion user has permissions to
these directories etc. The CQD is like the next preferred way giving the users
a way of setting the scratch settings if the settings at installation times
does not meet their expectations for certain very large overflow queries. With
the CQD only the mxosrvrs need to be bounced. But the user will have to ensure
, manually, that the directories specified by the CQD has Trafodion user
permissions.So I think we do need to make the change int he installer as well.
That's what JIRA 2114 is for. Ofcourse it needs to be prioritized against other
install work :)
> Use of CQD to set scratch directory locations
> ---------------------------------------------
>
> Key: TRAFODION-2146
> URL: https://issues.apache.org/jira/browse/TRAFODION-2146
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: foundation, sql-exe
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
>
> Allow a CQD specification to override the env settings for STFS locations.
> Currently the scratch directory locations and set at installtion time . The
> STFS layer that manages the scratch file creation reads the envvar in ms.env
> to determine where to create the scratch files.
> Now we allow a CQD to be specified that will override the envvar setting. If
> the CQD is not set (empty) , the envvar setting will work. This will give the
> user some flexibility to change scratch directory locations. The requirement
> is that the directoryies MUST exists on every node and that Trafodion user
> will need permissions to write to those directories. If not an error will be
> returned when a query invliving sort/hash overflow is executed. .
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
