[MarkLogic Dev General] date scalar type error in SQL view
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.
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:
> SQL generated:
> SELECT 1 AS "Number of Records",
> Date("mtable"."createdOn") AS "createdOn",
> "mtable"."type" AS "type"
> FROM "matchTable"."mtable" "mtable"
> LIMIT 1000
> [SQL] XDMP-UNDFUN: (err:XPST0017) Undefined function date()
> Trying with MarkLogic version 9.0-3.1 and Tableau v10.4.2
> Please help here.
> General mailing list
> General at developer.marklogic.com
> Manage your subscription at:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the General