presto与hive的集成不起作用

mitkmikd  于 2021-05-27  发布在  Hadoop
关注(0)|答案(1)|浏览(635)

我安装了hadoop 3.2.1,在hadoop的顶部安装了hive 3.1.2在单节点centos7上,我想与presto搜索引擎集成,这样我就可以在presto-server-0.229中看到hive的数据库了。hive工作得很好,能够创建表,我已经在官方的帮助下完成了presto-server-0.229的安装和配置文件。但我无法从presto访问数据库。

  1. Here are my all configuration details:
  2. Hive-site.xml:
  3. <property>
  4. <name>javax.jdo.option.ConnectionURL</name>
  5. <value>jdbc:mysql://10.0.0.96/metastore_db?createDatabaseIfNotExist=true</value>
  6. <description>metadata is stored in a MySQL server</description>
  7. </property>
  8. <property>
  9. <name>javax.jdo.option.ConnectionDriverName</name>
  10. <value>com.mysql.jdbc.Driver</value>
  11. <description>MySQL JDBC driver class</description>
  12. </property>
  13. <property>
  14. <name>javax.jdo.option.ConnectionUserName</name>
  15. <value>hiveuser</value>
  16. <description>user name for connecting to mysql server </description>
  17. </property>
  18. <property>
  19. <name>javax.jdo.option.ConnectionPassword</name>
  20. <value>hivepassword</value>
  21. <description>password for connecting to mysql server </description>
  22. </property>
  23. <property>
  24. <name>hive.metastore.uris</name>
  25. <value>thrift://10.0.0.96:9083</value>
  26. <description>Hive metastore Thrift server</description>
  27. </property>
  28. Presto Directories and files details:
  29. drwxrwxrwx 3 root root 98 Nov 21 05:58 bin
  30. drwxr-xr-x 3 root root 87 Nov 22 10:55 etc
  31. drwxrwxrwx 2 root root 8192 Nov 21 05:30 lib
  32. -rwxrwxrwx 1 root root 191539 Nov 15 05:57 NOTICE
  33. drwxrwxrwx 31 root root 4096 Nov 21 05:30 plugin
  34. -rwxrwxrwx 1 root root 126 Nov 15 05:57 README.txt
  35. [root@master presto-server-0.229]# cd etc/
  36. [root@master etc]# ll
  37. total 12
  38. drwxr-xr-x 2 root root 51 Nov 23 20:38 catalog
  39. -rwxrwxrwx 1 root root 240 Nov 22 10:55 config.properties
  40. -rwxrwxrwx 1 root root 171 Nov 21 05:33 jvm.config
  41. -rwxrwxrwx 1 root root 104 Nov 21 05:31 node.properties
  42. [root@master etc]# cd catalog
  43. [root@master catalog]# ll
  44. total 8
  45. -rwxrwxrwx 1 root root 173 Nov 23 20:38 hive.properties
  46. -rw-r--r-- 1 root root 19 Nov 21 06:01 jmx.properties
  47. [root@master catalog]# cd ..
  48. [root@master etc]# cd ..
  49. [root@master presto-server-0.229]# cd bin/
  50. [root@master bin]# ll
  51. total 14708
  52. -rwxrwxrwx 1 root root 1450 Oct 9 21:28 launcher
  53. -rwxrwxrwx 1 root root 78 Nov 15 06:12 launcher.properties
  54. -rwxrwxrwx 1 root root 14173 Oct 9 21:28 launcher.py
  55. -rwxr-xr-x 1 root root 15033453 Dec 15 2018 presto
  56. drwxrwxrwx 4 root root 47 Nov 15 06:12 procname
  57. -rwxrwxrwx 1 root root 173 Nov 23 20:38 hive.properties
  58. -rw-r--r-- 1 root root 19 Nov 21 06:01 jmx.properties
  59. hive.properties file configuration:
  60. [root@master catalog]# cat hive.properties
  61. connector.name=hive-hadoop3
  62. hive.metastore.uri=thrift://10.0.0.96:9083
  63. Please help me
cidc1ykv

cidc1ykv1#

presto.229不支持配置单元3。
当前支持配置单元3:
由星暴普雷斯托323-e( connector.name 仍然是 hive-hadoop2 尽管如此)
由普雷斯托在qubole的平台(我不知道配置细节)。
presto在hive 3支持方面的工作正在进行中,您可以在此处进行跟踪:https://github.com/prestosql/presto/issues/1218.
因为你可能会有后续的疑难解答,比如不太合适的问题,所以我建议你加入 #troubleshooting 在普雷斯托社区闲散。如果你选择星暴普雷斯托选项,有 #starburst 频道也在那松弛。

相关问题