Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Distinct in SQL query

  1. #1
    Join Date
    Feb 2011
    Posts
    240

    Default Distinct in SQL query

    Hi,

    I've a table input step, if into sql I insert the command SELECT DISTINCT the pc crashes (this does not happen if I delete the distinct).

    How can I do?

    Thanks
    Mariarita

  2. #2
    Join Date
    Sep 2011
    Posts
    190

    Default

    Could you be a bit more specific?

    What is crashing? Your Spoon environment? Your databaseserver? Your entire PC?
    When does it crash? During preview? During running?
    Have you tried running the query in a query-tool like SQLplus/TOAD/SQL Developer/...etc. What happens then?

  3. #3
    Join Date
    Feb 2011
    Posts
    240

    Default

    My Spoon environment and during preview.
    This query is ok in a query-tool

  4. #4
    Join Date
    Feb 2009
    Posts
    321

    Default

    have you tried with changing the sentence "distinct" to "group by" and grouping for the same fields? anyway I have done many querys with "distinct" sentence

  5. #5
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    If Spoon crashes it's probably an ODBC driver problem, most likely codepage conversion woes in the driver.

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.