[
https://issues.apache.org/jira/browse/TRAFODION-2146?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15412588#comment-15412588
]
ASF GitHub Bot commented on TRAFODION-2146:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/647#discussion_r73969461
--- Diff: core/sqf/src/stfs/stfs_stub.cpp ---
@@ -115,6 +115,7 @@ namespace STFS_stub {
} stfs_directories;
stfs_directories stfsDirsHDD_, stfsDirsSSD_;
+ char scratchCQDLocationString_[MAX_STFS_LOCATIONS*STFS_PATH_MAX -
STFS_SUFFIX+1]="";
--- End diff --
This seems to allow space for just under 32*4096 = 131072 bytes, but I
notice the DEFAULTS table limits CQD values to 1000 bytes. Just wondering what
the maximum CQD value length at the command line is and whether you'll ever
even get close to 131072 here.
> 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)
