Hi,
I have quite a strange issue with Metabase, created question via native query, the query result keeps changing when I click run with the same query. tried with DBeaver using same database and same query the query result is correct and never changing even run it multiple times.
I have attached a screen recording for Metabase and DBeaver
Thank you,
Environment :
Server
Distributor ID: Ubuntu
Description: Ubuntu 20.04.3 LTS
Release: 20.04
Codename: focal
DB server : 10.5.13-MariaDB-1:10.5.13+maria~focal mariadb.org binary distribution
DB Engine : Columnstore
Metabase version : 0.41.5
Client
Windows 11
Chrome browser Version 96.0.4664.110 (Official Build) (64-bit)
Attachment
dbschema
-- dwh.acc_dimdept definition
CREATE TABLE `acc_dimdept` (
`DBID` varchar(10) DEFAULT NULL,
`DeptID` varchar(10) DEFAULT NULL,
`DeptName` varchar(30) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1;
-- dwh.acc_exp_accountmap definition
CREATE TABLE `acc_exp_accountmap` (
`DBID` varchar(10) DEFAULT NULL,
`MainAccount` varchar(30) DEFAULT NULL,
`CostCenter` varchar(10) DEFAULT NULL,
`map1` varchar(50) DEFAULT NULL,
`map2` varchar(50) DEFAULT NULL,
`map3` varchar(50) DEFAULT NULL,
`map4` varchar(50) DEFAULT NULL,
`map5` varchar(50) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1;
-- dwh.acc_exp_bal definition
CREATE TABLE `acc_exp_bal` (
`DBID` varchar(10) DEFAULT NULL,
`CompanyID` varchar(10) DEFAULT NULL,
`BalDate` date DEFAULT NULL,
`MainAccount` varchar(20) DEFAULT NULL,
`CostCenter` varchar(10) DEFAULT NULL,
`DeptID` varchar(10) DEFAULT NULL,
`BalAmount` double DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=latin1;
-- dwh.vacc_plant_expense_a source
CREATE OR REPLACE
ALGORITHM = UNDEFINED VIEW `vacc_plant_expense_a` AS
select
`acc_exp_bal`.`DBID` AS `dbid`,
concat(`acc_exp_bal`.`DBID`, '-', `acc_exp_bal`.`CompanyID`) AS `companyid`,
`acc_exp_bal`.`BalDate` AS `baldate`,
`acc_exp_bal`.`MainAccount` AS `mainaccount`,
`acc_exp_bal`.`CostCenter` AS `costcenter`,
`acc_exp_bal`.`DeptID` AS `deptid`,
`acc_exp_bal`.`BalAmount` AS `balamount`,
`acc_exp_accountmap`.`map1` AS `map1`,
`acc_exp_accountmap`.`map3` AS `map3`,
`acc_exp_accountmap`.`map4` AS `map4`,
`acc_exp_accountmap`.`map5` AS `map5`,
`acc_dimdept`.`DeptName` AS `deptname`
from
((`acc_exp_bal`
join `acc_exp_accountmap` on
(`acc_exp_accountmap`.`DBID` = `acc_exp_bal`.`DBID`
and `acc_exp_accountmap`.`MainAccount` = `acc_exp_bal`.`MainAccount`))
left join `acc_dimdept` on
(`acc_dimdept`.`DBID` = `acc_exp_bal`.`DBID`
and `acc_dimdept`.`DeptID` = `acc_exp_bal`.`DeptID`))
where
`acc_exp_accountmap`.`CostCenter` is null
and `acc_exp_bal`.`CostCenter` is null
union
select
`acc_exp_bal`.`DBID` AS `dbid`,
concat(`acc_exp_bal`.`DBID`, '-', `acc_exp_bal`.`CompanyID`) AS `companyid`,
`acc_exp_bal`.`BalDate` AS `baldate`,
`acc_exp_bal`.`MainAccount` AS `mainaccount`,
`acc_exp_bal`.`CostCenter` AS `costcenter`,
`acc_exp_bal`.`DeptID` AS `deptid`,
`acc_exp_bal`.`BalAmount` AS `balamount`,
`acc_exp_accountmap`.`map1` AS `map1`,
`acc_exp_accountmap`.`map3` AS `map3`,
`acc_exp_accountmap`.`map4` AS `map4`,
`acc_exp_accountmap`.`map5` AS `map5`,
`acc_dimdept`.`DeptName` AS `deptname`
from
((`acc_exp_bal`
join `acc_exp_accountmap` on
(`acc_exp_accountmap`.`DBID` = `acc_exp_bal`.`DBID`
and `acc_exp_accountmap`.`MainAccount` = `acc_exp_bal`.`MainAccount`
and `acc_exp_accountmap`.`CostCenter` = `acc_exp_bal`.`CostCenter`))
left join `acc_dimdept` on
(`acc_dimdept`.`DBID` = `acc_exp_bal`.`DBID`
and `acc_dimdept`.`DeptID` = `acc_exp_bal`.`DeptID`));