![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
presto
大数据开发工程师-宋权
攻城狮,嗷!!!!
展开
-
presto连接greenplum(亲测好用)
Presto配置依据官网介绍(https://prestodb.io/docs/current/installation/deployment.html)按步骤配置并启动presto。下载presto-server并解压重命名为presto,进入presto并新建etc、data文件夹;依据官网介绍,在etc文件夹下增加并配置presto各配置文件。 3. 增加postgresql的配置文件,配置文件路径为presto/etc/catalog/postgresql.properties,..转载 2021-12-23 11:39:06 · 418 阅读 · 0 评论 -
presto配置mysql连接(亲测好用)
准备准备两台机器,机器名为 bd1 和 bd2,,并且在这两个节点上安装 hadoop,hive,并且准备一个mysql数据库。bd1 - coordinator节点bd2 - worker节点安装 presto serverwget -c https://repo1.maven.org/maven2/com/facebook/presto/presto-server/0.211/presto-server-0.211.tar.gztar zxvf presto-server-0.211.ta转载 2021-12-22 14:31:32 · 2023 阅读 · 0 评论 -
presto时间比较
d.time> timestamp '2018-06-11 00:00' 日期用`timestamp`转换即可用原创 2021-12-15 15:32:34 · 1021 阅读 · 0 评论 -
presto时间范围查询语句date(只能用天)
SELECT longitude, latitude, correct_longitude, correct_latitude, lac AS daqu, angle, task_id, equip_id, gps_timeFROM station_union_testWHERE 1 = 1 AND equip_id = '4726853c737a9898fc241615779058' and task_id='620' AND gps_tim...原创 2021-12-15 15:26:55 · 1020 阅读 · 0 评论 -
hive连接Presto
配置 Hive Connectoretc/catalog/hive.propertiesconnector.name=hive-hadoop2hive.metastore.uri=thrift://<hive_metastore_ip>:9083hive.config.resources=/opt/presto-server-0.211/etc/cluster/core-site.xml,/opt/presto-server-0.211/etc/cluster/hdfs-si..转载 2021-12-06 15:27:24 · 1173 阅读 · 0 评论