[MarkLogic Dev General] date scalar type error in SQL view

Harry Bakken dnaguy at gmail.com
Wed Jan 17 11:07:24 PST 2018


Been there, got that. Make sure you're using the absolute latest ODBC
driver and that you are connecting to Tableau *exactly *as described in the
documentation for ML9. If you use the wrong driver (ie, from the Tableau
UI) with ML9, you will see this error.

http://docs.marklogic.com/guide/sql/tableau

Regards,
Harry

On Wed, Jan 10, 2018 at 6:31 AM, Rajesh Kumar <rajava543 at gmail.com> wrote:

> Hi Team,
>
> I'm trying on TDE concept of MarkLogic by connecting MarkLogic with
> Tableau. Created a template and facing an issue while viewing the schema.
> When scalar-type is defined as date , MarkLogic is returning error.
>
> Sample Column defined:
>
> <column>
>     <name>createdOn</name>
>     <scalar-type>date</scalar-type>
>     <val>createdOn</val>
> </column>
>
> SQL generated:
> SELECT 1 AS "Number of Records",
>   Date("mtable"."createdOn") AS "createdOn",
>    "mtable"."type" AS "type"
> FROM "matchTable"."mtable" "mtable"
> LIMIT 1000
>
> error:
> [SQL] XDMP-UNDFUN: (err:XPST0017) Undefined function date()
>
>
> Trying with MarkLogic version 9.0-3.1 and Tableau v10.4.2
>
> Please help here.
>
> Thanks,
> Rajesh
>
> _______________________________________________
> General mailing list
> General at developer.marklogic.com
> Manage your subscription at:
> http://developer.marklogic.com/mailman/listinfo/general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://developer.marklogic.com/pipermail/general/attachments/20180117/8fba26f8/attachment.html 


More information about the General mailing list