Cast data type

tomato · May 1, 2020, 5:23pm

Can I cast a column to anther datatype, I had a column is EXPCURRENCY datatype, but I need cast to NUMBER datatype for formatting.

flamber · May 1, 2020, 5:34pm

Hi @tomato
I guess you’re using SQL Server?
I’m not sure if it makes a difference if you change Field Type to “Number” in Admin > Data Model.
If that doesn’t work, then a database view is probably your best solution.

tomato · May 1, 2020, 5:52pm

changes from the Admin -> Data Model has no effect. Can I cast it in native SQL, would that work?

flamber · May 1, 2020, 5:54pm

@tomato Yes, you should be able to do that, and then you can use that question as the source for other questions via Saved Questions. But there’s several other limitations you might experience.

tomato · May 1, 2020, 5:55pm

is there any plan to add it in as enhancement in future release?

flamber · May 1, 2020, 5:57pm

@tomato
Have you tried to create a Custom Column, where you use formula like [column] * 1 - I’m not sure, since it depends on the database if it changes the column type (most likely to FLOAT)

tomato · May 1, 2020, 5:58pm

I’ve tried create a Custom column, but not allow me to user the Cast function in the formula.

flamber · May 1, 2020, 5:59pm

@tomato I know, that function doesn’t exists. What happens if you just use this:

[column] * 1

tomato · May 1, 2020, 6:00pm

that works.

tomato · May 14, 2020, 4:30pm

Hi, I run into error when drilling down the data from graph after using custom column with [column] * 1

:joins [{:strategy :inner-join, :source-table 3666, :condition [:= [:field-id 34446] [:joined-field “BLT_BILL_AMT” [:field-id 34680]]], :alias “BLT_BILL_AMT”}],
:filter
[:and
[:= [:datetime-field [:field-id 34409] :year] [:relative-datetime 0 :year]]
[:= [:field-id 34419] [:value “LA” {:base_type :type/Text, :special_type :type/Category, :database_type “varchar”}]]],
:expressions {:Total Bill Amount [:* [:field-id 34390] 1]},
:fields
[[:field-id 34446]
[:field-id 34427]
[:field-id 34400]
[:field-id 34385]
[:field-id 34431]
[:field-id 34392]
[:field-id 34437]
[:datetime-field [:field-id 34409] :default]
[:field-id 34417]
[:field-id 34416]
[:field-id 34395]
[:field-id 34402]
[:field-id 34412]
[:field-id 34386]
[:field-id 34430]
[:field-id 34380]
[:field-id 34396]
[:datetime-field [:field-id 34438] :default]
[:field-id 34407]
[:datetime-field [:field-id 34387] :default]
[:field-id 34434]
[:field-id 34436]
[:field-id 34442]
[:field-id 34439]
[:datetime-field [:field-id 34428] :default]
[:field-id 34432]
[:field-id 34388]
[:field-id 34443]
[:datetime-field [:field-id 34391] :default]
[:datetime-field [:field-id 34410] :default]
[:datetime-field [:field-id 34415] :default]
[:datetime-field [:field-id 34420] :default]
[:field-id 34404]
[:field-id 34422]
[:field-id 34414]
[:field-id 34444]
[:datetime-field [:field-id 34421] :default]
[:field-id 34405]
[:field-id 34419]
[:field-id 34413]
[:field-id 34435]
[:field-id 34398]
[:field-id 34448]
[:field-id 34440]
[:field-id 34383]
[:datetime-field [:field-id 34425] :default]
[:field-id 34433]
[:field-id 34393]
[:field-id 34389]
[:field-id 34418]
[:field-id 34399]
[:field-id 34406]
[:field-id 34379]
[:datetime-field [:field-id 34384] :default]
[:field-id 34447]
[:field-id 34424]
[:field-id 34381]
[:field-id 34382]
[:field-id 34445]
[:field-id 34394]
[:field-id 34408]
[:field-id 34411]
[:field-id 34429]
[:field-id 34426]
[:datetime-field [:field-id 34403] :default]
[:datetime-field [:field-id 34401] :default]
[:datetime-field [:field-id 34397] :default]
[:datetime-field [:field-id 34441] :default]
[:field-id 34390]
[:field-id 34423]
[:expression “Total Bill Amount”]
[:joined-field “BLT_BILL_AMT” [:field-id 34713]]
[:joined-field “BLT_BILL_AMT” [:field-id 34699]]
[:joined-field “BLT_BILL_AMT” [:field-id 34687]]
[:joined-field “BLT_BILL_AMT” [:field-id 34707]]
[:joined-field “BLT_BILL_AMT” [:field-id 34680]]
[:joined-field “BLT_BILL_AMT” [:field-id 34709]]
[:joined-field “BLT_BILL_AMT” [:field-id 34691]]
[:joined-field “BLT_BILL_AMT” [:field-id 34711]]
[:joined-field “BLT_BILL_AMT” [:field-id 34712]]
[:joined-field “BLT_BILL_AMT” [:field-id 34690]]
[:joined-field “BLT_BILL_AMT” [:field-id 34689]]
[:joined-field “BLT_BILL_AMT” [:field-id 34678]]
[:joined-field “BLT_BILL_AMT” [:field-id 34679]]
[:joined-field “BLT_BILL_AMT” [:field-id 34702]]
[:joined-field “BLT_BILL_AMT” [:field-id 34704]]
[:joined-field “BLT_BILL_AMT” [:field-id 34684]]
[:joined-field “BLT_BILL_AMT” [:field-id 34686]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34706]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34685]]
[:joined-field “BLT_BILL_AMT” [:field-id 34696]]
[:joined-field “BLT_BILL_AMT” [:field-id 34692]]
[:joined-field “BLT_BILL_AMT” [:field-id 34710]]
[:joined-field “BLT_BILL_AMT” [:field-id 34705]]
[:joined-field “BLT_BILL_AMT” [:field-id 34683]]
[:joined-field “BLT_BILL_AMT” [:field-id 34695]]
[:joined-field “BLT_BILL_AMT” [:field-id 34694]]
[:joined-field “BLT_BILL_AMT” [:field-id 34701]]
[:joined-field “BLT_BILL_AMT” [:field-id 34693]]
[:joined-field “BLT_BILL_AMT” [:field-id 34708]]
[:joined-field “BLT_BILL_AMT” [:field-id 34697]]
[:joined-field “BLT_BILL_AMT” [:field-id 34688]]
[:joined-field “BLT_BILL_AMT” [:field-id 34714]]
[:joined-field “BLT_BILL_AMT” [:field-id 34698]]
[:joined-field “BLT_BILL_AMT” [:field-id 34703]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34682]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34681]]
[:joined-field “BLT_BILL_AMT” [:field-id 34700]]],
:limit 2000}},
:native nil,
:ex-data {:type :schema.core/error, :value [nil “Total Bill Amount”], :error [(named (not (map? nil)) arg0) nil]}}

flamber · May 14, 2020, 5:56pm

@tomato
Please post “Diagnostic Info” from Admin > Troubleshooting.
And the full stacktrace from Admin > Troubleshooting > Logs.

tomato · May 14, 2020, 6:10pm

this is happening to all the custom columns.

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.core Starting Metabase in STANDALONE mode
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.server Launching Embedded Jetty Webserver with config:
{:port 3000}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.core Starting Metabase version v0.34.3 (1a83edb release-0.34.x) …
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:57:34-07:00 INFO metabase.core System info:
{“java.runtime.name” “Java™ SE Runtime Environment”,
“java.runtime.version” “1.8.0_211-b12”,
“java.vendor” “Oracle Corporation”,
“java.vendor.url” “http://java.oracle.com/”,
“java.version” “1.8.0_211”,
“java.vm.name” “Java HotSpot™ Client VM”,
“java.vm.version” “25.211-b12”,
“os.name” “Windows 10”,
“os.version” “10.0”,
“user.language” “en”,
“user.timezone” “America/Los_Angeles”}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:47-07:00 ERROR metabase.driver.sql.query-processor Invalid HoneySQL form:
{:from ((identifier :table “dbo” “BLT_BILL”)),
:select
([(identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field-alias “TRAN_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “ANNUAL_TYPE”) (identifier :field-alias “ANNUAL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “AUTH_REQD”) (identifier :field-alias “AUTH_REQD”)]
[(identifier :field “dbo” “BLT_BILL” “AUTHORIZED”) (identifier :field-alias “AUTHORIZED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_CODE”) (identifier :field-alias “BILL_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_REASON”) (identifier :field-alias “BILL_ADJ_REASON”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_CATEGORY”) (identifier :field-alias “BILL_CATEGORY”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_DATE”) (identifier :field-alias “BILL_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_NUM”) (identifier :field-alias “BILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_PRINTED”) (identifier :field-alias “BILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_TYPE”) (identifier :field-alias “BILL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “BILLGRP_UNO”) (identifier :field-alias “BILLGRP_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BL_EMPL_UNO”) (identifier :field-alias “BL_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BRAGO”) (identifier :field-alias “BRAGO”)]
[(identifier :field “dbo” “BLT_BILL” “COVER_NUM”) (identifier :field-alias “COVER_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “CURRENCY_CODE”) (identifier :field-alias “CURRENCY_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_BY_UNO”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_BY_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_DATE”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_NUM”) (identifier :field-alias “DELAYED_SPLIT_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “DESELECT_DATE”) (identifier :field-alias “DESELECT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DISB_ADJ_CODE”) (identifier :field-alias “DISB_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DISTRIBUTION_METHOD_PREBILL”) (identifier :field-alias “DISTRIBUTION_METHOD_PREBILL”)]
[(identifier :field “dbo” “BLT_BILL” “DRUNO”) (identifier :field-alias “DRUNO”)]
[(identifier :field “dbo” “BLT_BILL” “EB_INITIATED”) (identifier :field-alias “EB_INITIATED”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_DATE”) (identifier :field-alias “EDIT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_EMPL_UNO”) (identifier :field-alias “EDIT_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_STATUS”) (identifier :field-alias “EDIT_STATUS”)]
[(identifier :field “dbo” “BLT_BILL” “FIRM_REFERENCE”) (identifier :field-alias “FIRM_REFERENCE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DI_DATE”) (identifier :field-alias “FROM_DI_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DP_DATE”) (identifier :field-alias “FROM_DP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TP_DATE”) (identifier :field-alias “FROM_TP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TT_DATE”) (identifier :field-alias “FROM_TT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “INTBILL_SESSION”) (identifier :field-alias “INTBILL_SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “IS_DELAYED_SPLIT”) (identifier :field-alias “IS_DELAYED_SPLIT”)]
[(identifier :field “dbo” “BLT_BILL” “IS_RFP_BILL”) (identifier :field-alias “IS_RFP_BILL”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_BILL_ACTION”) (identifier :field-alias “LAST_BILL_ACTION”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_MODIFIED”) (identifier :field-alias “LAST_MODIFIED”)]
[(identifier :field “dbo” “BLT_BILL” “MANUAL_PREPARE”) (identifier :field-alias “MANUAL_PREPARE”)]
[(identifier :field “dbo” “BLT_BILL” “OFFC”) (identifier :field-alias “OFFC”)]
[(identifier :field “dbo” “BLT_BILL” “ORIG_NUM”) (identifier :field-alias “ORIG_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PB_ADMIN_EDITOR_UNO”) (identifier :field-alias “PB_ADMIN_EDITOR_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_BILLING_COORD_UNO”) (identifier :field-alias “PB_BILLING_COORD_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_CURRENT_STATUS_UNO”) (identifier :field-alias “PB_CURRENT_STATUS_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_LAUNCH_METHOD”) (identifier :field-alias “PB_MARKUP_LAUNCH_METHOD”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_WF_NAME”) (identifier :field-alias “PB_MARKUP_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PB_PRINT_DATE”) (identifier :field-alias “PB_PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “PB_RESP_TK_UNO”) (identifier :field-alias “PB_RESP_TK_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_REVIEW_APPROVAL_WF_NAME”) (identifier :field-alias “PB_REVIEW_APPROVAL_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PERIOD”) (identifier :field-alias “PERIOD”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_NUM”) (identifier :field-alias “PREBILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_PRINTED”) (identifier :field-alias “PREBILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “PRIMARY_REGION”) (identifier :field-alias “PRIMARY_REGION”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_CURRENCY”) (identifier :field-alias “PRINT_CURRENCY”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_DATE”) (identifier :field-alias “PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “RELEASED”) (identifier :field-alias “RELEASED”)]
[(identifier :field “dbo” “BLT_BILL” “RULE_EXCEPT”) (identifier :field-alias “RULE_EXCEPT”)]
[(identifier :field “dbo” “BLT_BILL” “SB_TYPE”) (identifier :field-alias “SB_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “SESSION”) (identifier :field-alias “SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “SPLIT_DETAIL”) (identifier :field-alias “SPLIT_DETAIL”)]
[(identifier :field “dbo” “BLT_BILL” “SPOT_RATE”) (identifier :field-alias “SPOT_RATE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_CODE”) (identifier :field-alias “TC_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_TOTAL_BILL_AMT”) (identifier :field-alias “TC_TOTAL_BILL_AMT”)]
[(identifier :field “dbo” “BLT_BILL” “TEXT_ID”) (identifier :field-alias “TEXT_ID”)]
[(identifier :field “dbo” “BLT_BILL” “TIME_ADJ_CODE”) (identifier :field-alias “TIME_ADJ_CODE”)]),
:where
[:and
[:=
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (identifier :field “dbo” “BLT_BILL” “BILL_DATE”)))
(hsql/call :cast (identifier :field “dbo” “BLT_BILL” “BILL_DATE”) {:s “date”}))
{:s “datetime”})
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (hsql/call :dateadd {:s “week”} -1 :%getdate)))
(hsql/call :cast (hsql/call :dateadd {:s “week”} -1 :%getdate) {:s “date”}))
{:s “datetime”})]
[:= (identifier :field “dbo” “BLT_BILL” “OFFC”) “LA”]],
:join ([(identifier :table “dbo” “BLT_BILL_AMT”) (identifier :table-alias “BLT_BILL_AMT”)] [:= (identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field “BLT_BILL_AMT” “BILL_TRAN_UNO”)]),
:modifiers [“TOP 2000”]}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:47-07:00 ERROR metabase.query-processor.middleware.mbql-to-native Error transforming MBQL query to native:
{:type :query,
:query
{:source-table 998,
:joins [{:strategy :inner-join, :source-table 3666, :condition [:= [:field-id 34446] [:joined-field “BLT_BILL_AMT” [:field-id 34680]]], :alias “BLT_BILL_AMT”}],
:filter
[:and
[:= [:datetime-field [:field-id 34409] :week] [:relative-datetime -1 :week]]
[:= [:field-id 34419] [:value “LA” {:base_type :type/Text, :special_type :type/Category, :database_type “varchar”}]]],
:expressions {:Total Bill Amount [:* [:field-id 34390] 1]},
:fields
[[:field-id 34446]
[:field-id 34427]
[:field-id 34400]
[:field-id 34385]
[:field-id 34431]
[:field-id 34392]
[:field-id 34437]
[:datetime-field [:field-id 34409] :default]
[:field-id 34417]
[:field-id 34416]
[:field-id 34395]
[:field-id 34402]
[:field-id 34412]
[:field-id 34386]
[:field-id 34430]
[:field-id 34380]
[:field-id 34396]
[:datetime-field [:field-id 34438] :default]
[:field-id 34407]
[:datetime-field [:field-id 34387] :default]
[:field-id 34434]
[:field-id 34436]
[:field-id 34442]
[:field-id 34439]
[:datetime-field [:field-id 34428] :default]
[:field-id 34432]
[:field-id 34388]
[:field-id 34443]
[:datetime-field [:field-id 34391] :default]
[:datetime-field [:field-id 34410] :default]
[:datetime-field [:field-id 34415] :default]
[:datetime-field [:field-id 34420] :default]
[:field-id 34404]
[:field-id 34422]
[:field-id 34414]
[:field-id 34444]
[:datetime-field [:field-id 34421] :default]
[:field-id 34405]
[:field-id 34419]
[:field-id 34413]
[:field-id 34435]
[:field-id 34398]
[:field-id 34448]
[:field-id 34440]
[:field-id 34383]
[:datetime-field [:field-id 34425] :default]
[:field-id 34433]
[:field-id 34393]
[:field-id 34389]
[:field-id 34418]
[:field-id 34399]
[:field-id 34406]
[:field-id 34379]
[:datetime-field [:field-id 34384] :default]
[:field-id 34447]
[:field-id 34424]
[:field-id 34381]
[:field-id 34382]
[:field-id 34445]
[:field-id 34394]
[:field-id 34408]
[:field-id 34411]
[:field-id 34429]
[:field-id 34426]
[:datetime-field [:field-id 34403] :default]
[:datetime-field [:field-id 34401] :default]
[:datetime-field [:field-id 34397] :default]
[:datetime-field [:field-id 34441] :default]
[:field-id 34390]
[:field-id 34423]
[:expression “Total Bill Amount”]
[:joined-field “BLT_BILL_AMT” [:field-id 34713]]
[:joined-field “BLT_BILL_AMT” [:field-id 34699]]
[:joined-field “BLT_BILL_AMT” [:field-id 34687]]
[:joined-field “BLT_BILL_AMT” [:field-id 34707]]
[:joined-field “BLT_BILL_AMT” [:field-id 34680]]
[:joined-field “BLT_BILL_AMT” [:field-id 34709]]
[:joined-field “BLT_BILL_AMT” [:field-id 34691]]
[:joined-field “BLT_BILL_AMT” [:field-id 34711]]
[:joined-field “BLT_BILL_AMT” [:field-id 34712]]
[:joined-field “BLT_BILL_AMT” [:field-id 34690]]
[:joined-field “BLT_BILL_AMT” [:field-id 34689]]
[:joined-field “BLT_BILL_AMT” [:field-id 34678]]
[:joined-field “BLT_BILL_AMT” [:field-id 34679]]
[:joined-field “BLT_BILL_AMT” [:field-id 34702]]
[:joined-field “BLT_BILL_AMT” [:field-id 34704]]
[:joined-field “BLT_BILL_AMT” [:field-id 34684]]
[:joined-field “BLT_BILL_AMT” [:field-id 34686]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34706]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34685]]
[:joined-field “BLT_BILL_AMT” [:field-id 34696]]
[:joined-field “BLT_BILL_AMT” [:field-id 34692]]
[:joined-field “BLT_BILL_AMT” [:field-id 34710]]
[:joined-field “BLT_BILL_AMT” [:field-id 34705]]
[:joined-field “BLT_BILL_AMT” [:field-id 34683]]
[:joined-field “BLT_BILL_AMT” [:field-id 34695]]
[:joined-field “BLT_BILL_AMT” [:field-id 34694]]
[:joined-field “BLT_BILL_AMT” [:field-id 34701]]
[:joined-field “BLT_BILL_AMT” [:field-id 34693]]
[:joined-field “BLT_BILL_AMT” [:field-id 34708]]
[:joined-field “BLT_BILL_AMT” [:field-id 34697]]
[:joined-field “BLT_BILL_AMT” [:field-id 34688]]
[:joined-field “BLT_BILL_AMT” [:field-id 34714]]
[:joined-field “BLT_BILL_AMT” [:field-id 34698]]
[:joined-field “BLT_BILL_AMT” [:field-id 34703]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34682]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34681]]
[:joined-field “BLT_BILL_AMT” [:field-id 34700]]],
:limit 2000},
:database 33,
:async? true,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 1,
:context :ad-hoc,
:nested? false,
:query-hash [-46, 66, 101, 70, -90, -98, 62, 28, 101, 95, 38, -68, -85, 16, -17, -27, 67, -15, 95, 31, -125, 95, 52, -45, 19, -84, 8, 39, 82, -41, -82, -88]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:48-07:00 ERROR metabase.driver.sql.query-processor Invalid HoneySQL form:
{:from ((identifier :table “dbo” “BLT_BILL”)),
:select
([(identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field-alias “TRAN_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “ANNUAL_TYPE”) (identifier :field-alias “ANNUAL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “AUTH_REQD”) (identifier :field-alias “AUTH_REQD”)]
[(identifier :field “dbo” “BLT_BILL” “AUTHORIZED”) (identifier :field-alias “AUTHORIZED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_CODE”) (identifier :field-alias “BILL_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_ADJ_REASON”) (identifier :field-alias “BILL_ADJ_REASON”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_CATEGORY”) (identifier :field-alias “BILL_CATEGORY”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_DATE”) (identifier :field-alias “BILL_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_NUM”) (identifier :field-alias “BILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_PRINTED”) (identifier :field-alias “BILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “BILL_TYPE”) (identifier :field-alias “BILL_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “BILLGRP_UNO”) (identifier :field-alias “BILLGRP_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BL_EMPL_UNO”) (identifier :field-alias “BL_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “BRAGO”) (identifier :field-alias “BRAGO”)]
[(identifier :field “dbo” “BLT_BILL” “COVER_NUM”) (identifier :field-alias “COVER_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “CURRENCY_CODE”) (identifier :field-alias “CURRENCY_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_BY_UNO”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_BY_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_COMPLETED_DATE”) (identifier :field-alias “DELAYED_SPLIT_COMPLETED_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DELAYED_SPLIT_NUM”) (identifier :field-alias “DELAYED_SPLIT_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “DESELECT_DATE”) (identifier :field-alias “DESELECT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “DISB_ADJ_CODE”) (identifier :field-alias “DISB_ADJ_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “DISTRIBUTION_METHOD_PREBILL”) (identifier :field-alias “DISTRIBUTION_METHOD_PREBILL”)]
[(identifier :field “dbo” “BLT_BILL” “DRUNO”) (identifier :field-alias “DRUNO”)]
[(identifier :field “dbo” “BLT_BILL” “EB_INITIATED”) (identifier :field-alias “EB_INITIATED”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_DATE”) (identifier :field-alias “EDIT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_EMPL_UNO”) (identifier :field-alias “EDIT_EMPL_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “EDIT_STATUS”) (identifier :field-alias “EDIT_STATUS”)]
[(identifier :field “dbo” “BLT_BILL” “FIRM_REFERENCE”) (identifier :field-alias “FIRM_REFERENCE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DI_DATE”) (identifier :field-alias “FROM_DI_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_DP_DATE”) (identifier :field-alias “FROM_DP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TP_DATE”) (identifier :field-alias “FROM_TP_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “FROM_TT_DATE”) (identifier :field-alias “FROM_TT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “INTBILL_SESSION”) (identifier :field-alias “INTBILL_SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “IS_DELAYED_SPLIT”) (identifier :field-alias “IS_DELAYED_SPLIT”)]
[(identifier :field “dbo” “BLT_BILL” “IS_RFP_BILL”) (identifier :field-alias “IS_RFP_BILL”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_BILL_ACTION”) (identifier :field-alias “LAST_BILL_ACTION”)]
[(identifier :field “dbo” “BLT_BILL” “LAST_MODIFIED”) (identifier :field-alias “LAST_MODIFIED”)]
[(identifier :field “dbo” “BLT_BILL” “MANUAL_PREPARE”) (identifier :field-alias “MANUAL_PREPARE”)]
[(identifier :field “dbo” “BLT_BILL” “OFFC”) (identifier :field-alias “OFFC”)]
[(identifier :field “dbo” “BLT_BILL” “ORIG_NUM”) (identifier :field-alias “ORIG_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PB_ADMIN_EDITOR_UNO”) (identifier :field-alias “PB_ADMIN_EDITOR_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_BILLING_COORD_UNO”) (identifier :field-alias “PB_BILLING_COORD_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_CURRENT_STATUS_UNO”) (identifier :field-alias “PB_CURRENT_STATUS_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_LAUNCH_METHOD”) (identifier :field-alias “PB_MARKUP_LAUNCH_METHOD”)]
[(identifier :field “dbo” “BLT_BILL” “PB_MARKUP_WF_NAME”) (identifier :field-alias “PB_MARKUP_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PB_PRINT_DATE”) (identifier :field-alias “PB_PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “PB_RESP_TK_UNO”) (identifier :field-alias “PB_RESP_TK_UNO”)]
[(identifier :field “dbo” “BLT_BILL” “PB_REVIEW_APPROVAL_WF_NAME”) (identifier :field-alias “PB_REVIEW_APPROVAL_WF_NAME”)]
[(identifier :field “dbo” “BLT_BILL” “PERIOD”) (identifier :field-alias “PERIOD”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_NUM”) (identifier :field-alias “PREBILL_NUM”)]
[(identifier :field “dbo” “BLT_BILL” “PREBILL_PRINTED”) (identifier :field-alias “PREBILL_PRINTED”)]
[(identifier :field “dbo” “BLT_BILL” “PRIMARY_REGION”) (identifier :field-alias “PRIMARY_REGION”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_CURRENCY”) (identifier :field-alias “PRINT_CURRENCY”)]
[(identifier :field “dbo” “BLT_BILL” “PRINT_DATE”) (identifier :field-alias “PRINT_DATE”)]
[(identifier :field “dbo” “BLT_BILL” “RELEASED”) (identifier :field-alias “RELEASED”)]
[(identifier :field “dbo” “BLT_BILL” “RULE_EXCEPT”) (identifier :field-alias “RULE_EXCEPT”)]
[(identifier :field “dbo” “BLT_BILL” “SB_TYPE”) (identifier :field-alias “SB_TYPE”)]
[(identifier :field “dbo” “BLT_BILL” “SESSION”) (identifier :field-alias “SESSION”)]
[(identifier :field “dbo” “BLT_BILL” “SPLIT_DETAIL”) (identifier :field-alias “SPLIT_DETAIL”)]
[(identifier :field “dbo” “BLT_BILL” “SPOT_RATE”) (identifier :field-alias “SPOT_RATE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_CODE”) (identifier :field-alias “TC_CODE”)]
[(identifier :field “dbo” “BLT_BILL” “TC_TOTAL_BILL_AMT”) (identifier :field-alias “TC_TOTAL_BILL_AMT”)]
[(identifier :field “dbo” “BLT_BILL” “TEXT_ID”) (identifier :field-alias “TEXT_ID”)]
[(identifier :field “dbo” “BLT_BILL” “TIME_ADJ_CODE”) (identifier :field-alias “TIME_ADJ_CODE”)]),
:where
[:and
[:=
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (identifier :field “dbo” “BLT_BILL” “BILL_DATE”)))
(hsql/call :cast (identifier :field “dbo” “BLT_BILL” “BILL_DATE”) {:s “date”}))
{:s “datetime”})
(hsql/call
:cast
(hsql/call
:dateadd
{:s “day”}
(hsql/call :- 1 (hsql/call :datepart {:s “weekday”} (hsql/call :dateadd {:s “week”} -1 :%getdate)))
(hsql/call :cast (hsql/call :dateadd {:s “week”} -1 :%getdate) {:s “date”}))
{:s “datetime”})]
[:= (identifier :field “dbo” “BLT_BILL” “OFFC”) “LA”]],
:join ([(identifier :table “dbo” “BLT_BILL_AMT”) (identifier :table-alias “BLT_BILL_AMT”)] [:= (identifier :field “dbo” “BLT_BILL” “TRAN_UNO”) (identifier :field “BLT_BILL_AMT” “BILL_TRAN_UNO”)]),
:modifiers [“TOP 2000”]}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T10:59:48-07:00 WARN metabase.query-processor.middleware.process-userland-query Query failure {:status :failed,
:class clojure.lang.ExceptionInfo,
:error “Input to expression-with-name does not match schema: \n\n\t [(named (not (map? nil)) arg0) nil] \n\n”,
:stacktrace
("–> mbql.util$fn__24784$expression_with_name__24789.invoke(util.clj:503)"
“driver.sql.query_processor$fn__69701.invokeStatic(query_processor.clj:200)”
“driver.sql.query_processor$fn__69701.invoke(query_processor.clj:196)”
“driver.sql.query_processor$as.invokeStatic(query_processor.clj:415)”
“driver.sql.query_processor$as.invoke(query_processor.clj:395)”
“driver.sql.query_processor$fn__70031$iter__70033__70037$fn__70038$fn__70039.invoke(query_processor.clj:450)”
“driver.sql.query_processor$fn__70031$iter__70033__70037$fn__70038.invoke(query_processor.clj:449)”
“driver.sql.query_processor$format_honeysql.invokeStatic(query_processor.clj:656)”
“driver.sql.query_processor$format_honeysql.invoke(query_processor.clj:650)”
“driver.sql.query_processor$mbql__GT_native.invokeStatic(query_processor.clj:761)”
“driver.sql.query_processor$mbql__GT_native.invoke(query_processor.clj:756)”
“driver.sql$fn__71296.invokeStatic(sql.clj:36)”
“driver.sql$fn__71296.invoke(sql.clj:34)”
“query_processor.middleware.mbql_to_native$query__GT_native_form$fn__37448.invoke(mbql_to_native.clj:17)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invokeStatic(mbql_to_native.clj:16)”
“query_processor.middleware.mbql_to_native$query__GT_native_form.invoke(mbql_to_native.clj:11)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__37455.invoke(mbql_to_native.clj:36)”
“query_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__40562.invoke(annotate.clj:541)”
“query_processor.middleware.annotate$add_column_info$fn__40468.invoke(annotate.clj:485)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__41503.invoke(cumulative_aggregations.clj:57)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__43430.invoke(resolve_joins.clj:184)”
“query_processor.middleware.limit$limit$fn__42138.invoke(limit.clj:19)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46195.invoke(results_metadata.clj:87)”
“query_processor.middleware.format_rows$format_rows$fn__42126.invoke(format_rows.clj:76)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__38215.invoke(add_dimension_projections.clj:234)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38866.invoke(add_source_metadata.clj:107)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__43480.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__38703.invoke(add_row_count_and_status.clj:16)”
“query_processor.middleware.driver_specific$process_query_in_context$fn__41578.invoke(driver_specific.clj:12)”
“query_processor.middleware.resolve_driver$resolve_driver$fn__43094.invoke(resolve_driver.clj:22)”
“query_processor.middleware.store$initialize_store$fn__46220$fn__46221.invoke(store.clj:11)”
“query_processor.store$do_with_store.invokeStatic(store.clj:46)”
“query_processor.store$do_with_store.invoke(store.clj:40)”
“query_processor.middleware.store$initialize_store$fn__46220.invoke(store.clj:10)”
“query_processor.middleware.async$async__GT_sync$fn__37366.invoke(async.clj:23)”
“query_processor.middleware.async_wait$runnable$fn__40619.invoke(async_wait.clj:89)”),
:query
{:type “query”,
:query
{:source-table 998,
:joins [{:fields “all”, :strategy “inner-join”, :source-table 3666, :condition ["=" [“field-id” 34446] [“joined-field” “BLT_BILL_AMT” [“field-id” 34680]]], :alias “BLT_BILL_AMT”}],
:filter [“and” [“time-interval” [“field-id” 34409] -1 “week”] ["=" [“field-id” 34419] “LA”]],
:expressions {:Total Bill Amount ["" [“field-id” 34390] 1]}},
:parameters [],
:async? true,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 1,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [-46, 66, 101, 70, -90, -98, 62, 28, 101, 95, 38, -68, -85, 16, -17, -27, 67, -15, 95, 31, -125, 95, 52, -45, 19, -84, 8, 39, 82, -41, -82, -88]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 1,
:context :ad-hoc,
:nested? false,
:query-hash [-46, 66, 101, 70, -90, -98, 62, 28, 101, 95, 38, -68, -85, 16, -17, -27, 67, -15, 95, 31, -125, 95, 52, -45, 19, -84, 8, 39, 82, -41, -82, -88]},
:preprocessing-level 1,
:database 33,
:query
{:source-table 998,
:joins [{:strategy :inner-join, :source-table 3666, :condition [:= [:field-id 34446] [:joined-field “BLT_BILL_AMT” [:field-id 34680]]], :alias “BLT_BILL_AMT”}],
:filter
[:and
[:= [:datetime-field [:field-id 34409] :week] [:relative-datetime -1 :week]]
[:= [:field-id 34419] [:value “LA” {:base_type :type/Text, :special_type :type/Category, :database_type “varchar”}]]],
:expressions {:Total Bill Amount [: [:field-id 34390] 1]},
:fields
[[:field-id 34446]
[:field-id 34427]
[:field-id 34400]
[:field-id 34385]
[:field-id 34431]
[:field-id 34392]
[:field-id 34437]
[:datetime-field [:field-id 34409] :default]
[:field-id 34417]
[:field-id 34416]
[:field-id 34395]
[:field-id 34402]
[:field-id 34412]
[:field-id 34386]
[:field-id 34430]
[:field-id 34380]
[:field-id 34396]
[:datetime-field [:field-id 34438] :default]
[:field-id 34407]
[:datetime-field [:field-id 34387] :default]
[:field-id 34434]
[:field-id 34436]
[:field-id 34442]
[:field-id 34439]
[:datetime-field [:field-id 34428] :default]
[:field-id 34432]
[:field-id 34388]
[:field-id 34443]
[:datetime-field [:field-id 34391] :default]
[:datetime-field [:field-id 34410] :default]
[:datetime-field [:field-id 34415] :default]
[:datetime-field [:field-id 34420] :default]
[:field-id 34404]
[:field-id 34422]
[:field-id 34414]
[:field-id 34444]
[:datetime-field [:field-id 34421] :default]
[:field-id 34405]
[:field-id 34419]
[:field-id 34413]
[:field-id 34435]
[:field-id 34398]
[:field-id 34448]
[:field-id 34440]
[:field-id 34383]
[:datetime-field [:field-id 34425] :default]
[:field-id 34433]
[:field-id 34393]
[:field-id 34389]
[:field-id 34418]
[:field-id 34399]
[:field-id 34406]
[:field-id 34379]
[:datetime-field [:field-id 34384] :default]
[:field-id 34447]
[:field-id 34424]
[:field-id 34381]
[:field-id 34382]
[:field-id 34445]
[:field-id 34394]
[:field-id 34408]
[:field-id 34411]
[:field-id 34429]
[:field-id 34426]
[:datetime-field [:field-id 34403] :default]
[:datetime-field [:field-id 34401] :default]
[:datetime-field [:field-id 34397] :default]
[:datetime-field [:field-id 34441] :default]
[:field-id 34390]
[:field-id 34423]
[:expression “Total Bill Amount”]
[:joined-field “BLT_BILL_AMT” [:field-id 34713]]
[:joined-field “BLT_BILL_AMT” [:field-id 34699]]
[:joined-field “BLT_BILL_AMT” [:field-id 34687]]
[:joined-field “BLT_BILL_AMT” [:field-id 34707]]
[:joined-field “BLT_BILL_AMT” [:field-id 34680]]
[:joined-field “BLT_BILL_AMT” [:field-id 34709]]
[:joined-field “BLT_BILL_AMT” [:field-id 34691]]
[:joined-field “BLT_BILL_AMT” [:field-id 34711]]
[:joined-field “BLT_BILL_AMT” [:field-id 34712]]
[:joined-field “BLT_BILL_AMT” [:field-id 34690]]
[:joined-field “BLT_BILL_AMT” [:field-id 34689]]
[:joined-field “BLT_BILL_AMT” [:field-id 34678]]
[:joined-field “BLT_BILL_AMT” [:field-id 34679]]
[:joined-field “BLT_BILL_AMT” [:field-id 34702]]
[:joined-field “BLT_BILL_AMT” [:field-id 34704]]
[:joined-field “BLT_BILL_AMT” [:field-id 34684]]
[:joined-field “BLT_BILL_AMT” [:field-id 34686]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34706]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34685]]
[:joined-field “BLT_BILL_AMT” [:field-id 34696]]
[:joined-field “BLT_BILL_AMT” [:field-id 34692]]
[:joined-field “BLT_BILL_AMT” [:field-id 34710]]
[:joined-field “BLT_BILL_AMT” [:field-id 34705]]
[:joined-field “BLT_BILL_AMT” [:field-id 34683]]
[:joined-field “BLT_BILL_AMT” [:field-id 34695]]
[:joined-field “BLT_BILL_AMT” [:field-id 34694]]
[:joined-field “BLT_BILL_AMT” [:field-id 34701]]
[:joined-field “BLT_BILL_AMT” [:field-id 34693]]
[:joined-field “BLT_BILL_AMT” [:field-id 34708]]
[:joined-field “BLT_BILL_AMT” [:field-id 34697]]
[:joined-field “BLT_BILL_AMT” [:field-id 34688]]
[:joined-field “BLT_BILL_AMT” [:field-id 34714]]
[:joined-field “BLT_BILL_AMT” [:field-id 34698]]
[:joined-field “BLT_BILL_AMT” [:field-id 34703]]
[:datetime-field [:joined-field “BLT_BILL_AMT” [:field-id 34682]] :default]
[:joined-field “BLT_BILL_AMT” [:field-id 34681]]
[:joined-field “BLT_BILL_AMT” [:field-id 34700]]],
:limit 2000}},
:native nil,
:ex-data {:type :schema.core/error, :value [nil “Total Bill Amount”], :error [(named (not (map? nil)) arg0) nil]}}

[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:06-07:00 INFO metabase.sync.util STARTING: step ‘sync-fields’ for sqlserver Database 33 ‘ADR_Reporting’
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:06-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:06-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:11-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:11-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:14-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:14-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:16-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:18-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘HOURS’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:21-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:21-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘COMMENT’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:22-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘EXPCURRENCY’ to a Field base_type, falling back to :type/.
[6b517a9d-6913-4962-a43b-f702527d03c0] 2020-05-14T11:00:22-07:00 WARN metabase.driver.sql-jdbc.sync Don’t know how to map column type ‘HOURS’ to a Field base_type, falling back to :type/*.

flamber · May 14, 2020, 6:20pm

@tomato
I think you’re seeing this issue:
https://github.com/metabase/metabase/issues/11519 - upvote by clicking on the first post
In the future, please only post the relevant error and use the </> button in the forum comment box, so it’s formatted as code.

tomato · May 14, 2020, 6:26pm

Is a bit different in my case than issues-11519, I didn’t change the column name in Metabase, just turn off the friendly name option.

Any plan to either fix the mapping “EXPCURRENCY” or fix the custom column issue?

flamber · May 14, 2020, 6:46pm

@tomato There’s 2000+ other issues. Please open an issue for this. And if you provide a way to reproduce it, then chances of it getting fixed is much higher.