So I'm guessing people don't use D2R with Microsoft SQL Server?
On Tue, Mar 29, 2011 at 8:21 AM, Juan Sequeda <[email protected]>wrote:
> Hi all
>
> I'm running D2R on Microsoft SQL Server. I playing around with the BSBM
> data. I'm running into the two following things:
>
> I'm running this query:
>
> SELECT ?title ?text WHERE {
> ?review bsbm:reviewFor <
> http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromProducer30/Product1358>
> .
> ?review dc:title ?title .
> ?review rev:text ?text .
> }
>
>
> The first issue, for those familiar to the BSBM benchmark and dataset, each
> review has a language. In the query, I'm not specifying the language. This
> is what I have in my mapping file (which is the exact as what is posted on
> the bsbm website).
>
> map:review_text1 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "en";
> d2rq:condition "review.language='en'";
> .
> map:review_text2 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "ja";
> d2rq:condition "review.language='ja'";
> .
> map:review_text3 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "zh";
> d2rq:condition "review.language='zh'";
> .
> map:review_text4 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "de";
> d2rq:condition "review.language='de'";
> .
> map:review_text5 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "fr";
> d2rq:condition "review.language='fr'";
> .
> map:review_text6 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "es";
> d2rq:condition "review.language='es'";
> .
> map:review_text7 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "ru";
> d2rq:condition "review.language='ru'";
> .
> map:review_text8 a d2rq:PropertyBridge;
> d2rq:belongsToClassMap map:review;
> d2rq:property rev:text;
> d2rq:column "review.text";
> d2rq:lang "ko";
> d2rq:condition "review.language='ko'";
>
> This issue is that the query is being rewritten to
>
> SELECT DISTINCT "T1_review"."reviewID", "T2_review"."title",
> "T1_review"."publisher", "T3_review"."text" FROM "review" AS "T3_review",
> "review" AS "T1_review", "product" AS "T1_product", "review" AS "T2_review"
> WHERE ("T1_product"."producerID" = 30 AND "T1_product"."productID" =
> "T1_review"."productID" AND "T1_product"."productID" = 1358 AND
> "T1_review"."publisher" = "T2_review"."publisher" AND
> "T1_review"."publisher" = "T3_review"."publisher" AND "T1_review"."reviewID"
> = "T2_review"."reviewID" AND "T1_review"."reviewID" = "T3_review"."reviewID"
> AND ("T3_review"."language"='zh'))
>
> It seems like 'zh' is the default language, or something like that. What am
> I doing wrong here?
>
> The second issue, and this seems like a MSSQL specific problem is that the
> previous SQL query does not run. This is the following error:
>
> The text data type cannot be selected as DISTINCT because it is not
> comparable.:
>
> Looks like in MSSQL you can't run DISTINCT on different datatypes. Who else
> has ran into this problem? How have you solved it? Does every query get
> rewritten into a SELECT DISTINCT?
>
> Thanks for your insight!
>
> Juan Sequeda
> +1-575-SEQ-UEDA
> www.juansequeda.com
>
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
d2rq-map-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/d2rq-map-devel
