Apache Pinot Daily Email Digest (2021-09-12)

[Pinot Slack Email Digest <ap...@gmail.com>]

### _#general_

  
 **@zineb.raiiss:** @zineb.raiiss has joined the channel  
 **@frank_gao2:** @frank_gao2 has joined the channel  

###  _#random_

  
 **@zineb.raiiss:** @zineb.raiiss has joined the channel  
 **@frank_gao2:** @frank_gao2 has joined the channel  

###  _#troubleshooting_

  
 **@zineb.raiiss:** @zineb.raiiss has joined the channel  
 **@frank_gao2:** @frank_gao2 has joined the channel  
 **@sina.tamizi:** Hey friends, I am trying to convert timezone based on
location field with transformation functions, but the real-time table does not
accept the config and after save the page goes blank.. `"ingestionConfig": {`
`"filterConfig": null,` `"transformConfigs": [` `{` `"columnName":
"e_time_stamp",` `"transformFunction": "Groovy({timestamp + '
Australia/Melbourne'}, timestamp)"` `},` `{` `"columnName":
"epoc_time_stamp",` `"transformFunction": "fromDateTime(e_time_stamp, 'yyyy-
MM-dd''T''HH:mm:ssZZZ')"` `},` `{` `"columnName": "a_time_stamp",`
`"transformFunction": "Groovy({state == 'QLD' ?
DATETIMECONVERT(epoc_time_stamp, '1:MILLISECONDS:EPOCH',
'1:SECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd''T''HH:mm:ss
tz(Australia/Queensland)', '1:SECONDS') : DATETIMECONVERT(epoc_time_stamp,
'1:MILLISECONDS:EPOCH', '1:SECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd''T''HH:mm:ss
tz(Australia/Melbourne)', '1:SECONDS')}, state)"` `}` `]` `},`  
**@mayanks:** Do you have access to controller log? May be there's an error in
the log?  
**@mayanks:** Also, you can try posting via curl from the swagger page?  
**@sina.tamizi:** not much in the controller log: `2021/09/12 04:49:43.585
INFO [StartServiceManagerCommand] [main] Started Pinot [CONTROLLER] instance
[Controller_10.12.2.133_9000] at 49.056s since launch` `WARNING: An illegal
reflective access operation has occurred` `WARNING: Illegal reflective access
by org.codehaus.groovy.reflection.CachedClass (file:/opt/pinot/lib/pinot-
all-0.9.0-SNAPSHOT-jar-with-dependencies.jar) to method
java.lang.Object.finalize()` `WARNING: Please consider reporting this to the
maintainers of org.codehaus.groovy.reflection.CachedClass` `WARNING: Use
--illegal-access=warn to enable warnings of further illegal reflective access
operations` `WARNING: All illegal access operations will be denied in a future
release` `2021/09/12 23:08:30.327 ERROR [CompletionServiceHelper] [grizzly-
http-server-28] Server: Server_10.12.2.133_8098 returned error: 404`
`2021/09/12 23:11:42.162 ERROR [CompletionServiceHelper] [grizzly-http-
server-23] Server: Server_10.12.2.133_8098 returned error: 404` `2021/09/12
23:20:55.468 ERROR [CompletionServiceHelper] [grizzly-http-server-19] Server:
Server_10.12.2.133_8098 returned error: 404` `2021/09/12 23:33:41.371 ERROR
[CompletionServiceHelper] [grizzly-http-server-7] Server:
Server_10.12.2.133_8098 returned error: 404`  
**@sina.tamizi:** I will try to post it via curl  
**@mayanks:** Seems like you are getting a 404  
**@sina.tamizi:** yeah but i can't figure out whats wrong with my
transformation configs  
**@sina.tamizi:** if I just create a normal table without the last
transformation it works fine: `"ingestionConfig": {` `"filterConfig": null,`
`"transformConfigs": [` `{` `"columnName": "e_time_stamp",`
`"transformFunction": "Groovy({timestamp + ' Australia/Melbourne'},
timestamp)"` `},` `{` `"columnName": "epoc_time_stamp",` `"transformFunction":
"fromDateTime(e_time_stamp, 'yyyy-MM-dd''T''HH:mm:ssZZZ')"` `},`  
\--------------------------------------------------------------------- To
unsubscribe, e-mail: dev-unsubscribe@pinot.apache.org For additional commands,
e-mail: dev-help@pinot.apache.org