Hi Abhinav I do accept that namespace should be used in XPath's for better performance.
The question in context is path range index which I believe have no impact once the content is indexed with a path range. May be I am wrong in my above statement. Would love to hear on path range indexes with and with our namespace from other ML experts :) Regards, Gnana -----Original Message----- From: general-boun...@developer.marklogic.com [mailto:general-boun...@developer.marklogic.com] On Behalf Of general-requ...@developer.marklogic.com Sent: 05 May 2014 01:24 To: general@developer.marklogic.com Subject: General Digest, Vol 119, Issue 6 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. Re: General Digest, Vol 119, Issue 4 (abhinav mishra) ---------------------------------------------------------------------- Message: 1 Date: Sun, 4 May 2014 12:03:56 +0530 From: abhinav mishra <abhinavmishr...@gmail.com> Subject: Re: [MarkLogic Dev General] General Digest, Vol 119, Issue 4 To: general@developer.marklogic.com Message-ID: <cacp7mw99yy1mm2waksoxfl7fyhocbu5uzh+q+v4matk+dsd...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" 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","=","m > odule",$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/tra > nsaction.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 > *************************************** > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://developer.marklogic.com/pipermail/general/attachments/20140504/4d52b520/attachment.html ------------------------------ _______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general End of General Digest, Vol 119, Issue 6 *************************************** 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. _______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general
