I meet a weired and tough problem, I created two connections in script, one is from spark, another is from postgre.
when I want to show sum(resolved) by day, it always shows 0 like below. but when I use sum(click), it works.
but if I create a KPI chart to show the total(resolved), it works. So it seems like the date column in postgre connection is not work?? after I deleted the spark_hive database selection, it works. WHY?? How to fix this? I just wanna use the same date column and format, it never happened in the same connection with multiple tables, but it doesnt work in simultaneously postgre and spark???
My load scriptexists two connectionsafter deleting spark_hive database connection