while connecting to tableau from pinot. getting th...
# troubleshootingd
Deepika Eswar
10/13/2022, 8:01 AMwhile connecting to tableau from pinot. getting this error while extracting. any help?
n
Navina
10/13/2022, 8:14 AM@Deepika Eswar it says could not connect to data source. is there more logs that you can check? seems like a connectivity issue?
d
Deepika Eswar
10/13/2022, 8:41 AMok thanks
Deepika Eswar
10/13/2022, 11:39 AM:{"e-code":"0xFAB9A2C5","e-source":"NeedsClassification","e-status-code":"2","msg":"\"Failed to execute query : SELECT Sample.Branch AS Branch,\n Sample.ClientName AS ClientName,\n Sample.CompletedStaffDate AS CompletedStaffDate,\n Sample.GroupName AS GroupName,\n Sample.Month AS Month,\n Sample.Role AS Role,\n Sample.StaffID AS StaffID,\n Sample.Staffname AS Staffname,\n Sample.State AS State,\n Sample.Status AS Status,\n Sample.TaskDescription AS TaskDescription,\n Sample.Username AS Username,\n Sample.Week AS Week,\n Sample.Year AS Year\nFROM Sample LIMIT 1000000\n\"","type":"ConnectivityException"},"sponsor":"IzfU/rDCkFbJHS0EPZBEii","type":"end"},"v":{"cols":0,"is-command":false,"protocol-class":"genericjdbc","protocol-id":20,"query-category":"Extract","query-hash":817374229,"query-trunc":"SELECT Sample.Branch AS Branch,\n Sample.ClientName AS ClientName,\n Sample.CompletedStaffDate AS CompletedStaffDate,\n Sample.GroupName AS GroupName,\n Sample.Month AS Month,\n Sample.Role AS Role,\n Sample.StaffID AS StaffID,\n Sample.Staffname AS Staffname,\n Sample.State AS State,\n Sample.Status AS Status,\n Sample.TaskDescription AS TaskDescription,\n Sample.Username AS Username,\n Sample.Week AS Week,\n Sample.Year AS Year\nFROM Sample","rows":0},"ctx":{}}
{"ts":"2022-10-13T144834.894","pid":1748,"tid":"3574","sev":"info","req":"-","sess":"-","site":"-","user":"-","k":"end-qp.run-query","l":{},"a":{"depth":4,"elapsed":60.012,"exclusive":0,"id":"IzfU/rDCkFbJHS0EPZBEii","name":"qp.run-query","res":{"alloc":{"e":0,"i":3.67e+04,"ne":0,"ni":418,"peak":0},"free":{"e":0,"i":2.03e+04,"ne":0,"ni":242},"kcpu":{"e":0,"i":0},"ntid":3,"ucpu":{"e":0,"i":2}},"rk":"exception","root":"MoIyiUDYEZ4KnwXus/Md+o","rv":{"msg":"\"Failed to execute query : SELECT Sample.Branch AS Branch,\n Sample.ClientName AS ClientName,\n Sample.CompletedStaffDate AS CompletedStaffDate,\n Sample.GroupName AS GroupName,\n Sample.Month AS Month,\n Sample.Role AS Role,\n Sample.StaffID AS StaffID,\n Sample.Staffname AS Staffname,\n Sample.State AS State,\n Sample.Status AS Status,\n Sample.TaskDescription AS TaskDescription,\n Sample.Username AS Username,\n Sample.Week AS Week,\n Sample.Year AS Year\nFROM Sample LIMIT 1000000\n\"","type":"QueryException"},"sponsor":"DrczGrQvEkOIF2MNfex61S
Deepika Eswar
10/13/2022, 11:39 AMgetting this
Deepika Eswar
10/13/2022, 11:39 AM@Navina
Deepika Eswar
10/13/2022, 11:40 AMFederated Evaluator failed: Failed to execute query in tableau
n
Navina
10/13/2022, 11:56 AMI haven't played around with Tableau before. But from the exception you pasted, it looks like it is still a connectivity issue?
Copy code
"e-code":"0xFAB9A2C5","e-source":"NeedsClassification","e-status-code":"2","msg":"\"Failed to execute query : ... ", "type":"ConnectivityException"0xFAB9A2C5Navina
10/13/2022, 11:57 AMalso, have you tried with a different query. ? do all queries return the same error ?
d
Deepika Eswar
10/13/2022, 12:36 PMactually the query loops for 100+ clients
Deepika Eswar
10/13/2022, 12:36 PMwe tried to load single client and test in tableau
Deepika Eswar
10/13/2022, 12:36 PMit works fine
Deepika Eswar
10/13/2022, 12:37 PMbut when 100+ clients loaded it is throwing error @Navina
Deepika Eswar
10/13/2022, 12:47 PMi will try with a different query and see how it works may be
k
Kishore G
10/13/2022, 2:47 PM
How are you configuring Pinot connection stein in tableau
d
Deepika Eswar
10/14/2022, 6:34 AMchanged query, it dint work @Navina
n
Navina
10/14/2022, 10:18 AM@Deepika Eswar can you share how you are configuring the connection string?