Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Wrong sql generated

  1. #1

    Default Wrong sql generated

    Hi all,

    does anyone know why Pentaho Metadata sometimes generates queries with the following error:

    SELECT DISTINCT (...) ,null.name AS COL2
    FROM (...)

    Here the problem is the "null.name". Some combinations of columns in the queries generate this kind of thing.

    I've already revised my metadata and the relationships but I don't know how it can happen. It seems it's missing some information.

    I'm using Pentaho Metadata Editor 2.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2007
    Posts
    78

    Default

    I have seen something similar before. There have been some metadata fixes (not the editor, but the library that uses the metadata and generates the queries) and they will be released in 3.0.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.