You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "vineethvp (via GitHub)" <gi...@apache.org> on 2024/02/14 17:03:33 UTC

[I] Invalid transform function JSONPATHDOUBLE [pinot]

vineethvp opened a new issue, #12422:
URL: https://github.com/apache/pinot/issues/12422

   I'm working on a pinot cluster with version 1.1.0.  I have created a table schema with one field as JSON element.  I have defined a JSON field and DOUBLE field in my schema.
   
   {
       "name" : "data",
       "dataType" : "JSON",
       "notNull" : false
       },{
         "name" : "machine_util",
         "dataType" : "DOUBLE",
         "notNull" : false
       },
   
   I'm using below transformation configs to flatten JSON files. 
   
    "transformConfigs": [
           {"columnName": "machine_util", "transformFunction": "JSONPATHDOUBLE(data, '$.machine_util')" }]
   
   I'm getting below error while creating table. I'm running this in a K8 cluster. The same code was working for me in a local setup using docker with same version.
   
   **{"code":400,"error":"Invalid transform function 'JSONPATHDOUBLE(data, $.cpu_util)' for column 'cpu_util'"}bash-4.2#** 
   
   I'm executing the commands to create table using a curl command within controller. 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

Re: [I] Invalid transform function JSONPATHDOUBLE [pinot]

Posted by "vineethvp (via GitHub)" <gi...@apache.org>.
vineethvp closed issue #12422: Invalid transform function JSONPATHDOUBLE
URL: https://github.com/apache/pinot/issues/12422


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

Re: [I] Invalid transform function JSONPATHDOUBLE [pinot]

Posted by "vineethvp (via GitHub)" <gi...@apache.org>.
vineethvp commented on issue #12422:
URL: https://github.com/apache/pinot/issues/12422#issuecomment-1945325033

   Hi,
   
   Not really. The error message shown was for a different field. Both fields have same transform applied.
   
   **{"code":400,"error":"Invalid transform function 'JSONPATHDOUBLE(data, $. machine_util)' for column 'machine_util'"}bash-4.2#**
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

Re: [I] Invalid transform function JSONPATHDOUBLE [pinot]

Posted by "abhioncbr (via GitHub)" <gi...@apache.org>.
abhioncbr commented on issue #12422:
URL: https://github.com/apache/pinot/issues/12422#issuecomment-1948815582

   Can you check the ponot version is same on docker and on K8s? Which Pinot version?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

Re: [I] Invalid transform function JSONPATHDOUBLE [pinot]

Posted by "abhioncbr (via GitHub)" <gi...@apache.org>.
abhioncbr commented on issue #12422:
URL: https://github.com/apache/pinot/issues/12422#issuecomment-1944440642

   Seems like a transform function looking for the `cpu_util ` value in the JSON, however as per the transformConfigs it's `machine_util `. Is this correct? 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org