Hi GP, you have used wild-carded path in the query. using * as a namespace prefix is not recommended. MarkLogic indexes elements by QName, not by local name. That means namespace wildcards won't utilize the index and will require a lot of filtering.
Try using actual namespace prefix in your query. Refer: http://developer.marklogic.com/blog/namespace-wildcards-in-xpath Regards, Abhinav Kumar Mishra On Sun, May 4, 2014 at 8:00 PM, <general-requ...@developer.marklogic.com>wrote: > Send General mailing list submissions to > general@developer.marklogic.com > > To subscribe or unsubscribe via the World Wide Web, visit > http://developer.marklogic.com/mailman/listinfo/general > or, via email, send a message with subject or body 'help' to > general-requ...@developer.marklogic.com > > You can reach the person managing the list at > general-ow...@developer.marklogic.com > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of General digest..." > > > Today's Topics: > > 1. path range query taking more time when multiple values are > supplied (gnanaprakash.bodire...@cognizant.com) > 2. mlcp question (Mohamad Thahir) > 3. Re: mlcp question (Geert Josten) > 4. Re: mlcp question (Mohamad Thahir) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 3 May 2014 15:34:20 +0000 > From: <gnanaprakash.bodire...@cognizant.com> > Subject: [MarkLogic Dev General] path range query taking more time > when multiple values are supplied > To: <general@developer.marklogic.com> > Message-ID: > <40dd2b6a3a9bee4ba85c1323bf868bcc26d1a...@ctsinchnsxmbh.cts.com> > Content-Type: text/plain; charset="iso-8859-1" > > Hi > > I am profiling one of my queries and found that path range query is taking > more time when multiple values are passed. > > Example: > > cts:path-range-query("*:resource/*:level/*:level/*:level/@type","=",("module","lesson","unit","day") > ,$case-insensitive-collation) > Shallow ?s: 600-900 > > takes more time than > > > cts:path-range-query("*:resource/*:level/*:level/*:level/@type","=","module",$case-insensitive-collation) > Shallow ?s: 60-80 > > Is this expected behaviour? Is there any other alternative approach of > using multiple values based path range query? > > Regards, > Gnanaprakash Bodireddy > > This e-mail and any files transmitted with it are for the sole use of the > intended recipient(s) and may contain confidential and privileged > information. If you are not the intended recipient(s), please reply to the > sender and destroy all copies of the original message. Any unauthorized > review, use, disclosure, dissemination, forwarding, printing or copying of > this email, and/or any action taken in reliance on the contents of this > e-mail is strictly prohibited and may be unlawful. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://developer.marklogic.com/pipermail/general/attachments/20140503/5eedb594/attachment-0001.html > > ------------------------------ > > Message: 2 > Date: Sat, 3 May 2014 12:37:58 -0400 > From: Mohamad Thahir <thahirmoha...@gmail.com> > Subject: [MarkLogic Dev General] mlcp question > To: general@developer.marklogic.com > Message-ID: <e4aff940-51ce-4caa-a7dd-479f529c7...@gmail.com> > Content-Type: text/plain; charset=us-ascii > > Hello, > > I am new to MarkLogic and not sure this is the appropriate platform to ask > question. If not, please guide me. > I am trying to load a .csv file and wanted to convert to XML format. I am > using MLCP and while I load without specifying any content type or input > file type, it loads as comma delimited. When I provide the parameters > -input_file_type and -delimiter > it does not load at all. Any suggestions? > > Also, is there a way to get the whole .csv file as one document than each > row becoming a document as specified in the Loading Content into MarkLogic > Server, section 7.7.9 > > > thanks > mohamad. > > ------------------------------ > > Message: 3 > Date: Sat, 3 May 2014 21:33:59 +0200 > From: "Geert Josten" <geert.jos...@gmail.com> > Subject: Re: [MarkLogic Dev General] mlcp question > To: "'MarkLogic Developer Discussion'" > <general@developer.marklogic.com> > Message-ID: <00e701cf6706$a2090ac0$e61b2040$@gmail.com> > Content-Type: text/plain; charset="us-ascii" > > Hi Mohamad, > > Can you please provide the complete command-line you used? > > Kind regards, > Geert > > -----Oorspronkelijk bericht----- > Van: general-boun...@developer.marklogic.com > [mailto:general-boun...@developer.marklogic.com] Namens Mohamad Thahir > Verzonden: zaterdag 3 mei 2014 18:38 > Aan: general@developer.marklogic.com > Onderwerp: [MarkLogic Dev General] mlcp question > > Hello, > > I am new to MarkLogic and not sure this is the appropriate platform to ask > question. If not, please guide me. > I am trying to load a .csv file and wanted to convert to XML format. I am > using MLCP and while I load without specifying any content type or input > file type, it loads as comma delimited. When I provide the parameters > -input_file_type and -delimiter it does not load at all. Any suggestions? > > Also, is there a way to get the whole .csv file as one document than each > row becoming a document as specified in the Loading Content into MarkLogic > Server, section 7.7.9 > > > thanks > mohamad. > _______________________________________________ > General mailing list > General@developer.marklogic.com > http://developer.marklogic.com/mailman/listinfo/general > > > > ------------------------------ > > Message: 4 > Date: Sat, 3 May 2014 17:03:00 -0400 > From: Mohamad Thahir <thahirmoha...@gmail.com> > Subject: Re: [MarkLogic Dev General] mlcp question > To: MarkLogic Developer Discussion <general@developer.marklogic.com> > Cc: Frank Sanders <frank.sand...@marklogic.com> > Message-ID: <f5268774-b346-4964-bc5f-f19229a03...@gmail.com> > Content-Type: text/plain; charset="us-ascii" > > Geert, Frank > Here is the command and run status: > > mlcp.sh import -host localhost -port 8010 -username admin -password mlE2R > -input_file_path /Thahir/KALTS/MarkLogic/Data/Census2.csv -mode local > -input_file_type delimited_text > > 14/05/03 16:53:00 INFO contentpump.ContentPump: Hadoop library version: > 2.0.0-alpha > 14/05/03 16:53:00 INFO contentpump.LocalJobRunner: Content type: XML > 14/05/03 16:53:00 WARN util.KerberosName: Kerberos krb5 configuration not > found, setting default realm to empty > 14/05/03 16:53:01 INFO input.FileInputFormat: Total input paths to process > : 1 > 14/05/03 16:53:03 INFO contentpump.LocalJobRunner: completed 100% > 14/05/03 16:53:03 INFO contentpump.LocalJobRunner: > com.marklogic.contentpump.ContentPumpStats: > 14/05/03 16:53:03 INFO contentpump.LocalJobRunner: > ATTEMPTED_INPUT_RECORD_COUNT: 0 > 14/05/03 16:53:03 INFO contentpump.LocalJobRunner: > SKIPPED_INPUT_RECORD_COUNT: 0 > 14/05/03 16:53:03 INFO contentpump.LocalJobRunner: Total execution time: 1 > sec > > It loads the data when I remove the -input_file_type delimited_text, but > the data get loaded in comma-delimited format. Here is the sample data: > > sample data: > USPS,GEOID,ALAND,AWATER,ALAND_SQMI,AWATER_SQMI,INTPTLAT,INTPTLONG > AL,101,15713029743,2275875249,6066.835,878.72,31.008681,-87.797812 > AL,102,26266710862,307026133,10141.634,118.543,31.702085,-86.076842 > AL,103,19538510390,470857739,7543.861,181.799,33.150564,-85.700228 > AL,104,23021812410,570326274,8888.772,220.204,34.118181,-87.21381 > AL,105,9524193916,464832293,3677.312,179.473,34.754994,-86.711133 > > When I tried it through Information Studio, the following error appears: > unable to process transaction: 1 ticket: > /tickets/ticket/12854564960031399777 XDMP-DOCROOTTEXT Invalid root > text 03 May 2014 14:22:01 > XDMP-DOCROOTTEXT: > xdmp:invoke("/MarkLogic/appservices/infostudio/transaction.xqy", > (fn:QName("", "args"), map:map(<map:map xmlns:xs=" > http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance"; xmlns:map=" > http://marklogic.com/xdmp/map";><map:entry key="ticket-id"><map:value > xsi:type="xs:string">/tick...</map:map>)), <options > xmlns="xdmp:eval"><database>7750980024187914416</database></options>) -- > Invalid root text > "USPS,GEOID,ALAND,AWATER,ALAND_SQMI,AWATER_SQMI,INTPTLAT,INTPTLONG > AL,101,15713029743,2275875249,6066.835,878.72,31.008681,-87.797812 AL,102,26266710862,307026133,10141.634,118.543,31.702085,-86.076842 AL,103,19538510390,470857739,7543.861,181.799,33.150564,-85.700228 AL,104,23021812410,570326274,8888.772,220.204,34.118181,-87.21381 AL,105,9524193916,464832293,3677.312,179.473,34.754994,-86.711133" > > at /Thahir/KALTS/MarkLogic/Data/Census2.csv line 1 > > In /MarkLogic/appservices/utils/common-amped.xqy on line 274 > In > amped-common:appservices-invoke("/MarkLogic/appservices/infostudio/transaction.xqy", > (fn:QName("", "args"), map:map(<map:map xmlns:xs=" > http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance"; xmlns:map=" > http://marklogic.com/xdmp/map";><map:entry key="ticket-id"><map:value > xsi:type="xs:string">/tick...</map:map>)), <options > xmlns="xdmp:eval"><database>7750980024187914416</database></options>) > $path = "/MarkLogic/appservices/infostudio/transaction.xqy" > $vars = (fn:QName("", "args"), map:map(<map:map xmlns:xs=" > http://www.w3.org/2001/XMLSchema"; xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance"; xmlns:map=" > http://marklogic.com/xdmp/map";><map:entry key="ticket-id"><map:value > xsi:type="xs:string">/tick...</map:map>)) > $options = <options > xmlns="xdmp:eval"><database>7750980024187914416</database></options> > In /MarkLogic/appservices/infostudio/info-impl.xqy on line 822 > In impl:do-transaction-stream("/Thahir/KALTS/MarkLogic/Data/Census2.csv", > "/tickets/ticket/12854564960031399777", xdmp:function(fn:QName(" > http://marklogic.com/extension/plugin/filescan";, "process-file")), > <info:options xmlns:info="http://marklogic.com/appservices/infostudio"/>, > xs:untypedAtomic("1"), "", ()) > $source-locations = "/Thahir/KALTS/MarkLogic/Data/Census2.csv" > $ticket-id = "/tickets/ticket/12854564960031399777" > $function = xdmp:function(fn:QName(" > http://marklogic.com/extension/plugin/filescan";, "process-file")) > $input-deltas = <info:options xmlns:info=" > http://marklogic.com/appservices/infostudio"/> > $transaction-index = 1 > $context = "" > $error-log-level = () > $database = "mthahir" > $args = map:map(<map:map xmlns:xs="http://www.w3.org/2001/XMLSchema"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:map=" > http://marklogic.com/xdmp/map";><map:entry key="ticket-id"><map:value > xsi:type="xs:string">/tick...</map:map>) > $_ = () > In /MarkLogic/appservices/infostudio/tasks/transaction-manager.xqy on line > 62 > $count = xs:unsignedLong("1") > $end = 10 > $ticket-id = "/tickets/ticket/12854564960031399777" > $ticket = <ticket id="/tickets/ticket/12854564960031399777" > timestamp="2014-05-03T14:22:01.552069-04:00" xmlns=" > http://marklogic.com/appservices/infostudio > "><status>active</status><start-time>2014-05-03T14:22:01.444391-04...</ticket> > $active = fn:true() > $done = () > $policy-name = "10052664469819278165" > $policy-deltas = <info:options xmlns:info=" > http://marklogic.com/appservices/infostudio"/> > $collector-options = <options > xmlns="xdmp:document-get"><encoding>auto</encoding><format>xml</format></options> > $transaction = <transaction document-count="1" > ticket-id="/tickets/ticket/12854564960031399777" database="mthahir" > index="1" xmlns="http://marklogic.com/appservices/infostudio > "><source-location>/Thahir/KALTS/MarkLogic/Data/Census2.csv</sourc...</transaction> > $trace = "Ticket /tickets/ticket/12854564960031399777 loading task: 1 > tran..." > $source-locations = "/Thahir/KALTS/MarkLogic/Data/Census2.csv" > > > > On May 3, 2014, at 3:33 PM, Geert Josten wrote: > > > Hi Mohamad, > > > > Can you please provide the complete command-line you used? > > > > Kind regards, > > Geert > > > > -----Oorspronkelijk bericht----- > > Van: general-boun...@developer.marklogic.com > > [mailto:general-boun...@developer.marklogic.com] Namens Mohamad Thahir > > Verzonden: zaterdag 3 mei 2014 18:38 > > Aan: general@developer.marklogic.com > > Onderwerp: [MarkLogic Dev General] mlcp question > > > > Hello, > > > > I am new to MarkLogic and not sure this is the appropriate platform to > ask > > question. If not, please guide me. > > I am trying to load a .csv file and wanted to convert to XML format. I am > > using MLCP and while I load without specifying any content type or input > > file type, it loads as comma delimited. When I provide the parameters > > -input_file_type and -delimiter it does not load at all. Any > suggestions? > > > > Also, is there a way to get the whole .csv file as one document than each > > row becoming a document as specified in the Loading Content into > MarkLogic > > Server, section 7.7.9 > > > > > > thanks > > mohamad. > > _______________________________________________ > > General mailing list > > General@developer.marklogic.com > > http://developer.marklogic.com/mailman/listinfo/general > > > > _______________________________________________ > > General mailing list > > General@developer.marklogic.com > > http://developer.marklogic.com/mailman/listinfo/general > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://developer.marklogic.com/pipermail/general/attachments/20140503/1e3fb9c4/attachment.html > > ------------------------------ > > _______________________________________________ > General mailing list > General@developer.marklogic.com > http://developer.marklogic.com/mailman/listinfo/general > > > End of General Digest, Vol 119, Issue 4 > *************************************** >
_______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general
