metabase/crate-driver

Metabase driver for CrateDB. Community-supported.

crate-driver's Issues

Error when filter and grouping by datetime field

I'm using

• https://github.com/metabase/crate-driver/releases/download/1.0.0-crate-jdbc-2.3.0/crate.metabase-driver.jar
• running Metabase 0.32.0-snapshot

My Raw Data

My Aggregation by Time Create
Error : No method in multimethod 'date' for dispatch value: [:crate :day]

Errol log
02-08 13:57:12 ?[1mWARN metabase.query-processor?[0m :: Query failure: No method in multimethod 'date' for dispatch value: [:crate :day] ("--> query_processor$assert_query_status_successful.invokeStatic(query_processor.clj:286)" "query_processor$assert_query_status_successful.invoke(query_processor.clj:278)" "query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:324)" "query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:317)" "query_processor$fn__39788$process_query_and_save_execution_BANG___39793$fn__39794.invoke(query_processor.clj:355)" "query_processor$fn__39788$process_query_and_save_execution_BANG___39793.invoke(query_processor.clj:341)" "query_processor$fn__39814$process_query_and_save_with_max_BANG___39819$fn__39820.invoke(query_processor.clj:387)" "query_processor$fn__39814$process_query_and_save_with_max_BANG___39819.invoke(query_processor.clj:382)" "api.dataset$fn__43558$fn__43561.invoke(dataset.clj:45)" "api.common$fn__24629$invoke_thunk_with_keepalive__24634$fn__24635$fn__24636.invoke(common.clj:435)")

Got Error when add crateDB :valid false, :dbname

Using : Metabase 0.33.0-preview2

Driver Crate : https://github.com/metabase/crate-driver/releases/download/1.0.1-crate-jdbc-2.3.0/crate.metabase-driver.jar

Got Error :
08-06 15:31:47 DEBUG middleware.log :: POST /api/database 400 2 ms (0 DB calls) {:valid false, :dbname "No method in multimethod 'connection-details->spec' for dispatch value: :crate", :message "No method in multimethod 'connection-details->spec' for dispatch value: :crate"}

Failed connection to crate db with user/password

Hi,

My Metabase 0.34.3 is running on a AWS EC2 and my Crate 4.1.2 is running on another AWS EC2 instance.

I do not access to Crate through the default credentials (user: "crate" / password: none) but with custom credentials.

The metabase/crate-driver doesn't allow custom credentials connection.

As I didn't know how to add user/password fields in metabase front, I am posting here the unsecured solution we found :

In the file /crate-driver/src/metabase/driver/crate.clj, we updated rows 203-206

   {:classname   "io.crate.client.jdbc.CrateDriver"
    :subprotocol "crate"
    :subname     (str "//" hosts)
    :user        "crate"}

with our custom credentials :

   {:classname   "io.crate.client.jdbc.CrateDriver"
    :subprotocol "crate"
    :subname     (str "//" hosts)
    :user        "<your_username>"
    :password    "<your_password>"}

Now it perfectly works !

If you have a better option, I am happy to hear it :-)

Connection Failed Metabase v0.38.2 using crate-metabase-driver.jar

Hi,

I am trying to connect my locally hosted metabase to locally hosted cratedb on Ubunti 20.04.
I have copied the driver (crate.metabase-driver.jar) under the plugins folder of metabase.
Going by the option in metabase: admin -> databases -> add database option, drop down shows cratedb option.
I give the database a name and use default setting localhost:5432/; on pressing save it turns red "Failed". I tried changing to localhost:4200/ also yielded same result.

Will be great if I can get some help

thanks!

there does not seem to be SHA hashes posted for the crate-driver (for metabase)

there does not seem to be SHA hashes posted for the crate-driver (for metabase)

would it be possible, to do this, just as the metabase.jar releases have posted SHA hashes?

do not support with metabase Metabase 0.32.9

{"message":"No method in multimethod 'connection-properties' for dispatch value: :crate","type":"class java.lang.IllegalArgumentException","stacktrace":["clojure.lang.MultiFn.getFn(MultiFn.java:156)","clojure.lang.MultiFn.invoke(MultiFn.java:229)","--> driver.util$available_drivers_info$iter__24018__24022$fn__24023.invoke(util.clj:114)","driver.util$available_drivers_info.invokeStatic(util.clj:112)","driver.util$available_drivers_info.invoke(util.clj:108)","public_settings$public_settings.invokeStatic(public_settings.clj:211)","public_settings$public_settings.invoke(public_settings.clj:197)","routes.index$load_entrypoint_template.invokeStatic(index.clj:68)","routes.index$load_entrypoint_template.invoke(index.clj:65)","routes.index$entrypoint.invokeStatic(index.clj:82)","routes.index$entrypoint.invoke(index.clj:77)","middleware.exceptions$catch_uncaught_exceptions$fn__73023.invoke(exceptions.clj:104)","middleware.exceptions$catch_api_exceptions$fn__73020.invoke(exceptions.clj:92)","middleware.log$log_api_call$fn__73472.invoke(log.clj:162)","middleware.security$add_security_headers$fn__72978.invoke(security.clj:105)","middleware.json$wrap_json_body$fn__73259.invoke(json.clj:63)","middleware.json$wrap_streamed_json_response$fn__73277.invoke(json.clj:97)","middleware.session$bind_current_user$fn__71350$fn__71351.invoke(session.clj:193)","middleware.session$do_with_current_user.invokeStatic(session.clj:177)","middleware.session$do_with_current_user.invoke(session.clj:170)","middleware.session$bind_current_user$fn__71350.invoke(session.clj:192)","middleware.session$wrap_current_user_id$fn__71335.invoke(session.clj:161)","middleware.session$wrap_session_id$fn__71320.invoke(session.clj:123)","middleware.auth$wrap_api_key$fn__72918.invoke(auth.clj:27)","middleware.misc$maybe_set_site_url$fn__73553.invoke(misc.clj:58)","middleware.misc$bind_user_locale$fn__73556.invoke(misc.clj:74)","middleware.misc$add_content_type$fn__73541.invoke(misc.clj:30)","middleware.misc$disable_streaming_buffering$fn__73578.invoke(misc.clj:119)","middleware.misc$wrap_gzip$fn__73571.invoke(misc.clj:101)"]}

Create Database Error

OSX, Crate 4.0.3
Metabase 0.33.0.0

When pressing SAVE button in Add Database page throws error :
No method in multimethod 'connection-details->spec' for dispatch value: :crate
I can connect to crate if using database type Postgres, but metabase can not browse the table data.

My question: How to specify user and password?