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 <rajava...@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@developer.marklogic.com > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general