Hi team, I have a parquet file in which one record...
# troubleshooting
r
Hi team, I have a parquet file in which one record is like this
Copy code
[{"A_applied_weight_amount_double":94.4,"A_awb_code":"**********","A_charge_weight_amount_double":null,"A_id":605966337,"A_shipment_id":820771786,"Ar_awb_id":605966337,"Ar_zone":"z_d","Is_deleted":false,"Merged_topic_ts_ms":"2025-05-07T03:57:59.695Z","O_created_at":"2025-05-02T09:53:31Z","O_customer_city":"K.V.Rangareddy","O_customer_pincode":"500079","O_customer_state":"Telangana","O_id":824402352,"O_net_total_double":1930,"O_payment_method":"prepaid","O_shipping_method":"SR","O_sla":48,"O_total_double":1930,"Op":"s","S_awb":"**********","S_awb_assign_date":"2025-05-02T09:53:32Z","S_company_id":4613330,"S_courier":"Delhivery Surface 2 Kgs","S_created_at":"2025-05-02T09:53:31Z","S_etd":"2025-05-06T10:56:41Z","S_id":820771786,"S_order_id":824402352,"S_rto_delivered_date":"1969-12-31T18:30:00Z","S_rto_initiated_date":"1969-12-31T18:30:00Z","S_sr_courier_id":44,"S_status":7,"S_updated_at":"2025-05-05T11:59:44Z","Ts_ms_kafka":"2025-05-07T03:57:59.695Z"}]
In this the s_created_at is
Copy code
"S_created_at":"2025-05-02T09:53:31Z"
but when ingesting them into pinot via LaunchDataIngestionSpec the same record was showing timestamp with 5:30 added why?
Copy code
{
  "columns": [
    "s_id",
    "s_created_at"
  ],
  "records": [
    [
      820771786,
      "2025-05-02 15:23:31.0"
    ]
  ]
}
here's a snap from pinot for same id: anyone can help? @Xiang Fu @Mayank
x
What's the machine timezone?
I feel the timestamp is ingested as IST and shown as UTC?
r
yeah only that was the issue. Thanks we resolved it👍