This message was deleted.
# generals
Slackbot
07/14/2022, 12:57 PMThis message was deleted.
k
Kartik Khare
07/14/2022, 1:03 PMno need to specify
httpKartik Khare
07/14/2022, 1:03 PMAlso the controller ip and all brokers ip need to be resolvable from your env
r
Rajkumar Samayanathan
07/27/2022, 4:54 PMHi @Kartik Khare sorry for the last conversation,
I connected the pinot with tableau.
I can't able to work live connection, so i switched to extract ,
the problem is when is comes to refresh Its showing error like this
Rajkumar Samayanathan
07/27/2022, 4:54 PMUnexpected Error
Failed to execute query : SELECT WelcomeEffortsReport.CallMade AS CallMade,
WelcomeEffortsReport.ClientName AS ClientName,
CAST(WelcomeEffortsReport.ContactedDate AS DATE) AS ContactedDate,
WelcomeEffortsReport.DidnotReachPt AS DidnotReachPt,
WelcomeEffortsReport.Reachedpt AS Reachedpt,
WelcomeEffortsReport.ReadingTaken AS ReadingTaken,
WelcomeEffortsReport.ReadyForOnProgram AS ReadyForOnProgram,
WelcomeEffortsReport.TeamMate AS TeamMate,
WelcomeEffortsReport.TrainingProvided AS TrainingProvided
FROM WelcomeEffortsReport
LIMIT 100
Error Code: FAB9A2C5
Unable to create extract
Rajkumar Samayanathan
07/27/2022, 4:54 PMCan you guide me through this your help is much needed
k
Kartik Khare
07/27/2022, 4:57 PMnot sure if CAST AS DATE will work
does it work before refresh
r
Rajkumar Samayanathan
07/27/2022, 4:57 PMYes i can create the dashboards with extracts
k
Kartik Khare
07/27/2022, 4:59 PMok
so I think what you need to do is check out the jprotocolserver.log in Tableau workspace dir
Kartik Khare
07/27/2022, 4:59 PMthat would give the whole stacktrace
r
Rajkumar Samayanathan
07/27/2022, 5:00 PMOkay. Ill check it now
Rajkumar Samayanathan
07/27/2022, 5:41 PMSorry i cant find anything like you mentioned in local system
k
Kartik Khare
07/27/2022, 5:42 PMare you running this in mac or some other system?
r
Rajkumar Samayanathan
07/27/2022, 5:43 PMwindowa
Rajkumar Samayanathan
07/27/2022, 5:43 PMwindows*
Rajkumar Samayanathan
07/27/2022, 5:56 PMis my error because my table is created with subqueries and injected into pinot ??
I come to see some of our group members said complex queries won't run on pinot
Rajkumar Samayanathan
07/27/2022, 6:06 PMi also getting error like this
An error occurred while communicating with the Other Databases (JDBC) data source 'WelcomeEffortsReport'
Bad Connection: Tableau could not connect to the data source.
Error Code: FAB9A2C5
Failed to execute query : SELECT WelcomeEffortsReport.TeamMate AS Calculation_1096063618921959424,
SUM(WelcomeEffortsReport.Reachedpt) AS TEMP_Calculation_1096063618933399555__238153781__0_,
COUNT(WelcomeEffortsReport.CallMade) AS TEMP_Calculation_1096063618933399555__4088127136__0_,
SUM(WelcomeEffortsReport.ReadyForOnProgram) AS TEMP_Calculation_1096063618934386692__107542655__0_,
SUM(WelcomeEffortsReport.TrainingProvided) AS TEMP_Calculation_1096063618934726661__2367264121__0_,
SUM(WelcomeEffortsReport.ReadingTaken) AS TEMP_Calculation_1096063618934882310__306705901__0_,
SUM(WelcomeEffortsReport.DidnotReachPt) AS sum_DidnotReachPt_ok
FROM WelcomeEffortsReport
WHERE (CAST(CAST( AS DATE) AS TIMESTAMP) = {fn TIMESTAMPADD(SQL_TSI_WEEK,-1,)})
GROUP BY 1 LIMIT 2147483647
SELECT WelcomeEffortsReport.TeamMate AS Calculation_1096063618921959424,
SUM(WelcomeEffortsReport.Reachedpt) AS TEMP_Calculation_1096063618933399555__238153781__0_,
COUNT(WelcomeEffortsReport.CallMade) AS TEMP_Calculation_1096063618933399555__4088127136__0_,
SUM(WelcomeEffortsReport.ReadyForOnProgram) AS TEMP_Calculation_1096063618934386692__107542655__0_,
SUM(WelcomeEffortsReport.TrainingProvided) AS TEMP_Calculation_1096063618934726661__2367264121__0_,
SUM(WelcomeEffortsReport.ReadingTaken) AS TEMP_Calculation_1096063618934882310__306705901__0_,
SUM(WelcomeEffortsReport.DidnotReachPt) AS sum_DidnotReachPt_ok
FROM WelcomeEffortsReport
WHERE (CAST(CAST( AS DATE) AS TIMESTAMP) = {fn TIMESTAMPADD(SQL_TSI_WEEK,-1,)})
GROUP BY 1