Prestodb在Kafka，Oracle和PostgreSQL上查询-柠檬ai自媒体

Prestodb��Kafka��Oracle��PostgreSQL�ϲ�ѯ

��prestodb.

��ǿ��Ե��Prestodb��Facebook��ķֲ�ʽSQL��ѯ��档��ϵ�Prestodb��Ҫ�û��У��Facebook��Netflix��Airbnb��Dropbox��Uber��Linkedin��Twitter��

Presto��ڲ�ѯPetabytes��ݵ�SQL��棨1��PBB��= 1,024 Tberabytes��ݿ�ʼ��Facebook��ת�Ƶ��Դ��硣 Presto��Hive��Cassandra��ϵ��ݿ⣬MongoDB��Kafka�ȡ��ӵ��ѯ��Դ��

��ǿ��ʹ�õ��ѯ��Դ��

��

���� Red Hat Enterprise Linux 7��

��Presto�ļ��

https��// repo1..maven.org./ maven2 / com / com / facebook / presto / presto-server / 0.254.1/ presto-server-0.254.1��.gz.

��Presto��б�Ҫ��ȡ��װ�ļ��С��ļ��У�

/ bin.

/ lib.��

/��

ע�⣺��ļ��з��ڰ�װĿ¼�⣬��ɵ��Ժ��Prestodb��

��

��Ҫ�� /�ȵ� �ļ��Presto��װĿ¼�£��·��ļ��

�ڵ��

ÿ��ڵ��еĻ�� ��node.properties����

node.environment = dev.

node.id =.Turkcell-presto-demo-ersin

node.data-dir =/ xxx / yyyy / presto / data

JVM Config.

��ѡ�� ��jvm.config����Java��

-��

-xmx16g.

-XX��+ USEGG1GC

-xx��g1heapregionsize = 32m

-xx��+ usegcoverheaddrimit

-xx��+ axplicicgcinvokesconcurrent

-xx��+ heapdumponoutofmemoryError

-xx��+ ExitOnoutofMemoryError

��

Ϊpresto�� ��config.properties��

Ŀ¼��

�� - ��Դ��

����/Ŀ¼��Ӧ��¶��´��Ŀ¼ /�ȵ� Ŀ¼��Ŀ��Դ��Ŀ¼��Ϣ��۽�ʹ��Դ��ʾ��ֽ��

��־��

��־�� - ��log.properties��

com.facebook.presto = Info.

prestodb�İ�װ��ϸ��Ϣ��

��

��ڴ˴��ҵ��

��ǽ�ʹ��ö��Դ�ķ��Ȩ�ޡ�

��ʾ

��Kafka-Oracle-PostgreSQL��Ŀ��ǽ�3��ͬ��Դ�뵥��SQL��/ etcĿ¼�´��/ catalogĿ¼��3��ͬ��Դ��¡�

Kafka.

��Kafka.properties�ļ��

Connector.name = Kafka.

Kafka.Table-names = turkcell.sqlite-jdbc-ttech

Kafka.nodes = localhost��9092

��һ��Ҫ��ѡ��Kafka�г��е��Ҫ��ҽ��ݱ��ΪKafka��JSON��Ա��ֽڻ�Avro֮��С��ඨ��Ϣ��ҪһЩ��á�� / kafka. ��洴��Ŀ¼ /�ȵ� Ŀ¼��Kafka��ƺ��Ҫ��ΪĿ¼��Kafka��ͬ��֡�

�ƺ��ģʽ�� Kafka.properties. ��ļ��turkcell��ˣ��洴��turkcell.sqlite-jdbc-ttech.json�ļ���/ etc / kafka ��JSON��ݿ��Ա��£�

10.

11.

12.

13.

14.

15.

16.

17.

18.

19.

20.

{

�� tablename�� ��sqlite-jdbc-ttech��

�� schemaname�� ��turkcell��

�� ơ�� ��turkcell.sqlite-jdbc-ttech��

�� Ϣ�� {

�� dataformat�� ��json��

�� Ұ�� [

�� {

�� ơ�� ��ID��

�� ӳ�䡱�� ��ID��

�� ͡�� ��

�� }��

�� {

�� ơ�� ��ơ��

�� ӳ�䡱�� ��ơ��

�� ͡�� ��varchar��

�� }

�� ]

�� }

}

�׹�� -����Oracle.properties�ļ��

1 2	`Connector.name = Oracle.` `connection-url = jdbc��Oracle��ݣ�ersin / pwd_user @ // xxyy.zz.tgc��9999 /��` `��`

postgreSQL -����PostgreSQL.Properties�ļ��

connector.name = postgreSQL.

connection-url = jdbc��postgreSQL��// localhost.��61061/ xxyydb.

�� - �û�=�û�

�� - ��= pwd_user

��ʹ�ú��Ļ��ͼ

�� ��/�� �ܡ���е��presto�� ڰ�װĿ¼�У�֮��ǿ��Բ鿴��Web��в�ѯ��ϸ��Ϣ ��Ĺ��ʱ��ж೤��˶೤ʱ��Դ��

��ǿ��ͨ��ӵ�presto CLI.��cli�� غ��ҽ��Ϊ��presto.jar. ��临�Ƶ��װĿ¼�С��ǿ��ʹ�ÿͻ��ͻ��Ӧ�ó����./presto.jar. ����ǿ��ֱ��дSQL��

һЩ��õ��

��ʾĿ¼;

10.

11.

12.

13.

presto>��ʾĿ¼;

��Ŀ¼

-------------

��jmx

��Kafka.

��Oracle.

��postgreSQL.

��ϵͳ

��5�У�

��

��ѯ20210615_124934_00009_9f6xw��ɣ�1�ڵ�

��ѣ�19�ܣ�19�� ��100.00��

0:00 [0�У�0b] [0��/ s.��0B./ s.]

��ʾOracle��ģʽ;

10.

11.

12.

13.

14.

15.

16.

17.

18.

presto>��ʾ�׹��ĵ�ģʽ;

�� ܹ�

-----------------------

��xx.

��yy.

��XXF.

��yy.

��

��BGFHGF.

��HJGHJ.

��....

��......

��

��ѯ20210615_125147_00012_9f6xw��ɣ�1�ڵ�

��ѣ�19�ܣ�19�� ��100.00��

1:13 [817�У�10.5kb] [11��/ s.��146B./ s.]

��ʾOracle.mutuser�ı��;

10.

presto>��Oracle.mutuser�ı��ʾ��;

�� 

-----------------------

��test1.

��test_2

��2�У�

��

��ѯ20210615_125418_00013_9f6xw��ɣ�1�ڵ�

��ѣ�19�ܣ�19�� ��100.00��

0:01 [2�У�72b] [2��/ s.��104b./ s.]

内容来源网络，如有侵权，联系删除，本文地址：https://www.230890.com/zhan/160392.html

Prestodb在Kafka，Oracle和PostgreSQL上查询

����prestodb.

������

���ʹ�ú���Ļ��ͼ

相关推荐

幸福是生病时的一杯白水，幸福是困难中的一声问候

申请专利有什么好处，买的专利评职称看得出

20左右香烟排行榜(10到20元香烟大全及价格)

蜜蜡多少钱一克?，蜜蜡的价格

坌塺的意思（字义,诗词）

被骗了你该怎么办？

��prestodb.

��

��ʹ�ú��Ļ��ͼ