Pentaho

 View Only
  • 1.  PDI Set Request Pool

    Posted 27 days ago

    Hi,

    I can set the request pool if the reference is hard coded ie 'mypreferredpool' via the advanced SQL option

    However I can't set the request pool using    set request_pool=mypoolvariable

    e.g having defined mypoolvariable as = 'mypreferrredpool' either as a parameter or variable

    Im using set request_pool=${mypoolvariable} from a parameter which runs without error

    Any help please

    Thanks

    Philip

    ------------------------------
    Philip Neale
    IT Support Manager
    Cognizant
    ------------------------------


  • 2.  RE: PDI Set Request Pool

    Posted 25 days ago
    Hi Philip

    Presuming you're connecting to Impala?  AFAIK the only way you could do it is to include your variable as part of a JDBC connection string like this:

    dbc:impala://[hostname]:[port];AuthMech=1;KrbHostFQDN=[kerberos host];KrbRealm=[realm];KrbServiceName=impala;REQUEST_POOL=${mypoolvariable}

    You set the JDBC string if you use a generic DB connection and specify the driver name you want to use.    I've done similar to pass TLS certificates to a Postgres connection.

    ------------------------------
    Andrew Cave
    Systems Engineer
    BizCubed Pty Ltd
    Australia
    ------------------------------



  • 3.  RE: PDI Set Request Pool

    Posted 22 days ago
    Hi Andrew

    Thanks very much for the reply, thats a great example

    I don't have direct access to the JDBC which happens to be HIVE

    but I will pass that over to the platform team

    I will update on any progress

    Regards

    Philip

    ------------------------------
    Philip Neale
    IT Support Manager
    Cognizant
    ------------------------------