无法使用nodejs查询clickhouse数据库

wz1wpwve 于 2021-07-15 发布在 ClickHouse

关注(0)|答案(1)|浏览(581)

我在查询clickhouse数据库时出错..”

const { ClickHouse } = require('clickhouse');
const clickhouse = new ClickHouse({
  debug: false,
  basicAuth: {
    username: 'username',
    password: 'password',
  },
});
clickhouse.query('SHOW DATABASES;').exec((err, rows) => {
  console.log(err);
  console.log(rows);
});

-->===输出=====
[nodemon]启动node index.js错误：getaddrinfo enotfound http at getaddrinforeqwrap.onlookup[as oncomplete]（dns.js:60:26）{errno:'enotfound'，code:'enotfound'，syscall:'getaddrinfo'，hostname:'http}未定义

clickhouse node.js

来源：https://stackoverflow.com/questions/57736425/cant-query-clickhouse-db-using-nodejs

1条答案

按热度按时间

lymnna711#

您应该指定clickhouse所在的主机和端口

const { ClickHouse } = require('clickhouse');
const clickhouse = new ClickHouse(url: process.env.DATABASE_HOST,
    port: parseInt(process.env.DATABASE_PORT),
    debug: false,
    basicAuth: {
        username: "username",
        password: "password"
    },
    isUseGzip: false,
    config: {
        session_timeout: 60,
        output_format_json_quote_64bit_integers: 0,
        enable_http_compression: 0
    });
clickhouse.query('SHOW DATABASES;').exec((err, rows) => {
console.log(err);
console.log(rows);
})

赞(0）回复(0）举报 2021-07-15

我来回答

无法使用nodejs查询clickhouse数据库

1条答案

相关问题

热门标签

最新问答