oodt-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Foster (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OODT-325) QueryTool does not retain query order
Date Tue, 04 Oct 2011 14:56:33 GMT

    [ https://issues.apache.org/jira/browse/OODT-325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13120183#comment-13120183
] 

Brian Foster commented on OODT-325:
-----------------------------------

the other possibility is the in QueryTool you could make the default value of the outputFormat
to the SELECT clause and just put $ in front of each element... until this is codified the
workaround for this issue is to just fill out outputFormat manually for each query... for
example your query above would become:

./query_tool --url http://localhost:9000 --sql -query "SELECT Observer,Description,Duration,ExperimentID
FROM KatFile WHERE Observer='jasper'" --sortBy Duration --outputFormat '$Observer,$Description,$Duration,$ExperimentID'
                
> QueryTool does not retain query order
> -------------------------------------
>
>                 Key: OODT-325
>                 URL: https://issues.apache.org/jira/browse/OODT-325
>             Project: OODT
>          Issue Type: Improvement
>          Components: file manager
>    Affects Versions: 0.3
>         Environment: OS X 10.7
> Java version "1.6.0_26"
>            Reporter: Thomas Bennett
>            Priority: Minor
>              Labels: features, newbie
>             Fix For: 0.4
>
>
> I've ingested some files into a lucene catalog and then use QueryTool query the catalog.
> $ ./query_tool --url http://localhost:9000 --sql -query "SELECT Observer,Description,Duration,ExperimentID
FROM KatFile WHERE Observer='jasper'" --sortBy Duration
> Which returns:
> ...
> jasper,a9909ae6-822b-11e0-a7a1-0060dd4721d8,Target track,637.841571569
> jasper,47c3a4da-822a-11e0-a7a1-0060dd4721d8,Target track,565.859450817
> jasper,777b0f34-8224-11e0-a7a1-0060dd4721d8,Target track,80.9798858166
> ...
> As you can see the order of the returned values seems to be arbitrary (I asked Observer,Description,Duration,ExperimentID
and it ruturned Observer,ExperimentID,Description,Duration)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message