Hive views are not supported

Get Help
1

Hi,

It seems hive views are not supported, is there any way to use view in metabase?

image
image706×258 13.3 KB

image

Any suggestion will be appreciated.

2

Hi @daniel.lee
Post "Diagnostic Info" from Admin > Troubleshooting.
The Presto driver currently uses HTTP instead of JDBC - work is being done to fix that, which should allow a more uniform functionality:
https://github.com/metabase/metabase/issues/8893 - upvote by clicking :+1: on the first post

3

thanks, @flamber

as of is it not possible to bring any view into metabase?

if there is any alternative way to achieve, please kindly tell me.

4

@daniel.lee

Post "Diagnostic Info" from Admin > Troubleshooting.

Try with the latest release, since I don't know. If it doesn't work, then I guess it won't be supported until the Presto driver is getting reworked.

5

@flamber,

below is diagnostic info from my workaround.

{
"browser-info": {
"language": "ko-KR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_242-b08",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_242",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.242-b08",
"os.name": "Linux",
"os.version": "3.10.0-957.21.3.el7.x86_64",
"user.language": "ko",
"user.timezone": "Asia/Seoul"
},
"metabase-info": {
"databases": [
"presto"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.31-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.36.6",
"date": "2020-09-17",
"branch": "master",
"hash": "e81939a"
},
"settings": {
"report-timezone": "Asia/Seoul"
}
}
}

6

@daniel.lee Latest release is 0.39.4: https://github.com/metabase/metabase/releases/latest

7

@flamber

Thanks, I'll discuss about upgrade with the team :slight_smile: