Pentaho

 View Only

  • 1.  PDI Set Request Pool

    Posted 06-01-2022 08:32

    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 06-02-2022 18:51
    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
    ------------------------------

    Original Message


  • 3.  RE: PDI Set Request Pool

    Posted 06-06-2022 03:35
    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
    ------------------------------

    Original Message


Related Content