Using SQL in Query Manager in MarkLogic

Question

After inserting few XML records in ML8, I was able to query them using XQuery through Query Console..

Lets say following XML's are there:

enter image description here

Say one XML contains data like:

    <?xml version="1.0" encoding="UTF-8"?>
     <Providers>
      <Provider>
       <ProviderId>1111</ProviderId>
       <Name>John Doe</Name>
       <Age>40</Age>
       <Country>MN</Country>
      </Provider>
      <Provider>
       <ProviderId>2222</ProviderId>
       <Name>Jane Doe</Name>
       <Age>42</Age>
       <Country>MS</Country>
      </Provider>
     </Providers>

There is an option to use SQL in query manager, can that be used here to run queries or some configurations are needed so that SQL can be used directly. If yes, any example will be very helpful.

Marcin · Accepted Answer · 2015-02-26 13:17:46Z

3

It's not possible to run SQL Queries directly on the XML - this needs to be configured, there is a good step-by-step guide here: https://docs.marklogic.com/guide/sql/setup

answered Feb 26, 2015 at 13:17

Marcin

19012 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ankit Goel Over a year ago

Thanks Marcin.. will go through the steps.

Sofia · Accepted Answer · 2016-07-05 09:54:33Z

3

It should also be noted that the model is, one-row = one-document, so you may need to revamp how you are loading your XML here.

edited Jul 5, 2016 at 9:54

Sofia

7691 gold badge8 silver badges22 bronze badges

answered Feb 26, 2015 at 14:09

mholstege

4,92214 silver badges7 bronze badges

Collectives™ on Stack Overflow

Using SQL in Query Manager in MarkLogic

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related