Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Infobright + PDI

  1. #1

    Default Infobright + PDI

    Hello,

    When trying to generate the SQL required to run transformations while using a Infobright connection, the SQL itself doesn't run, I get these type of errors:

    Code:
    Couldn't execute SQL: CREATE TABLE atribuicao_dim
    (
      atribuicao_id BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY
    , atribuicao VARCHAR(255)
    )
    
    Too many key parts specified; max 0 parts allowed
    Any suggestions on how to fix this issue is appreciated.

    - Pedro Ferreira

  2. #2
    Join Date
    Jan 2012
    Posts
    8

    Default

    Pedro, you probably figured it out since, but for others' benefit, the problem is that you are specifying a primary key, and Infobright doesn't allow PKs or any indexes for that matter.

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.