Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Epic] Catalog addtions for Metabase compatablity #746

Open
2 tasks done
RustomMS opened this issue Mar 13, 2023 · 2 comments
Open
2 tasks done

[Epic] Catalog addtions for Metabase compatablity #746

RustomMS opened this issue Mar 13, 2023 · 2 comments

Comments

@RustomMS
Copy link
Contributor

RustomMS commented Mar 13, 2023

@RustomMS
Copy link
Contributor Author

RustomMS commented Mar 13, 2023

Metabase steps:

sync-timezone:

  • error in transaction begin
  • error running to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.MS TZ')

sync-tables:

  • Passes with additional empty catalog builtins

sync-fields:

  • Error getting fields for tables synced
  • pg_attrdef table required
  • pg_get_expr required

@RustomMS
Copy link
Contributor Author

We are hitting an error due to a datafusion limitation on a where-in subquery filter clause used by metabase:
apache/datafusion#5633

For this query:

SELECT nspname, typname FROM pg_type t JOIN pg_namespace n ON n.oid = t.typnamespace WHERE t.oid IN (SELECT DISTINCT enumtypid FROM pg_enum e);

Though the result should be empty. Next one requires columns and types to be able to join together so working on a glare_types builtin table and pg_type builtin view

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants