{
  "_id": "6a1d70ab1d7bb097a0a5056f",
  "Package": "RClickhouse",
  "Type": "Package",
  "Title": "'Yandex Clickhouse' Interface for R with Basic 'dplyr' Support",
  "Version": "0.6.10",
  "Encoding": "UTF-8",
  "Authors@R": "c(\nperson(\"Christian\", \"Hotz-Behofsits\", email = \"christian.hotz-behofsits@wu.ac.at\", role = c(\"aut\", \"cre\")),\nperson(\"Daniel\", \"Winkler\", email = \"daniel.winkler@wu.ac.at\", role = c(\"aut\")),\nperson(\"Luca\", \"Rauchenberger\", email = \"luca.rauchenberger@wu.ac.at\", role = c(\"aut\")),\nperson(\"Peter\", \"Knaus\", email = \"peter.knaus@wu.ac.at\", role = c(\"aut\")),\nperson(\"Clemens\", \"Danninger\", email = \"cran@b8000h.org\", role = c(\"aut\")),\nperson(\"Daria\", \"Yudaeva\", email = \"daria.yudaeva@wu.ac.at\", role = c(\"aut\")),\nperson(\"Simon\", \"Stiebellehner\", email = \"simon.stiebellehner@gmail.com\", role = c(\"aut\")),\nperson(\"Dan\", \"Egnor\", role = c(\"aut\")),\nperson(\"Vlad\", \"Losev\", email = \"vladl@google.com\", role = c(\"aut\")),\nperson(\"Keith\", \"Ray\", email = \"keith.ray@gmail.com\", role = c(\"aut\")),\nperson(\"Zhanyong\", \"Wan\", email = \"wan@google.com\", role = c(\"aut\")),\nperson(\"Markus\", \"Heule\", email = \"mheule@google.com\", role = c(\"aut\")),\nperson(\"Oliver\", \"Flasch\", email = \"oflasch@gmail.com\", role = c(\"aut\")),\nperson(family = \"Google\", role = c(\"cph\")),\nperson(\"Yann\", \"Collet\", role = c(\"cph\", \"aut\"), comment = \"Yann Collet is the author and copyright holder of 'lz4'\")\n)",
  "Description": "'Yandex Clickhouse' (<https://clickhouse.com/>) is a\nhigh-performance relational column-store database to enable big\ndata exploration and 'analytics' scaling to petabytes of data.\nMethods are provided that enable working with 'Yandex\nClickhouse' databases via 'DBI' methods and using\n'dplyr'/'dbplyr' idioms.",
  "License": "GPL-2",
  "Roxygen": "list(markdown = TRUE)",
  "RoxygenNote": "7.3.2",
  "NeedsCompilation": "yes",
  "Collate": "'RcppExports.R' 'RClickhouse.R' 'ClickhouseDriver.R'\n'ClickhouseConnection.R' 'ClickhouseResult.R'\n'dbplyr-helpers.R' 'dplyr.R' 'zzz.R'",
  "URL": "https://github.com/IMSMWU/RClickhouse",
  "BugReports": "https://github.com/IMSMWU/RClickhouse/issues",
  "Config/pak/sysreqs": "libicu-dev",
  "Repository": "https://imsmwu.r-universe.dev",
  "Date/Publication": "2025-02-27 00:52:51 UTC",
  "RemoteUrl": "https://github.com/imsmwu/rclickhouse",
  "RemoteRef": "HEAD",
  "RemoteSha": "1a54f1a34d31936565a3dddc1825e866e36c0188",
  "Packaged": {
    "Date": "2026-06-01 11:36:42 UTC",
    "User": "root"
  },
  "Author": "Christian Hotz-Behofsits [aut, cre],\nDaniel Winkler [aut],\nLuca Rauchenberger [aut],\nPeter Knaus [aut],\nClemens Danninger [aut],\nDaria Yudaeva [aut],\nSimon Stiebellehner [aut],\nDan Egnor [aut],\nVlad Losev [aut],\nKeith Ray [aut],\nZhanyong Wan [aut],\nMarkus Heule [aut],\nOliver Flasch [aut],\nGoogle [cph],\nYann Collet [cph, aut] (Yann Collet is the author and copyright holder\nof 'lz4')",
  "Maintainer": "Christian Hotz-Behofsits <christian.hotz-behofsits@wu.ac.at>",
  "MD5sum": "b26a5e207cc56f552dcbadbad88f4e87",
  "_user": "imsmwu",
  "_type": "src",
  "_file": "RClickhouse_0.6.10.tar.gz",
  "_fileid": "49cb70826a75f85f1962ee67b42f3bf45155ce040d1c24feb4a8e7545541b247",
  "_filesize": 223012,
  "_sha256": "49cb70826a75f85f1962ee67b42f3bf45155ce040d1c24feb4a8e7545541b247",
  "_created": "2026-06-01T11:36:42.000Z",
  "_published": "2026-06-01T11:44:43.785Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 78843883077,
      "time": 168,
      "config": "linux-devel-arm64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7330479126"
    },
    {
      "job": 78843883091,
      "time": 159,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7330476401"
    },
    {
      "job": 78843883064,
      "time": 172,
      "config": "linux-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7330481137"
    },
    {
      "job": 78843883055,
      "time": 145,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7330472116"
    },
    {
      "job": 78843883086,
      "time": 181,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7330477158"
    },
    {
      "job": 78843883128,
      "time": 408,
      "config": "macos-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7330552783"
    },
    {
      "job": 78843883071,
      "time": 190,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7330478993"
    },
    {
      "job": 78843883084,
      "time": 282,
      "config": "macos-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7330510955"
    },
    {
      "job": 78843385044,
      "time": 190,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7330424923"
    },
    {
      "job": 78843883103,
      "time": 148,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7330473124"
    },
    {
      "job": 78843883080,
      "time": 194,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "7330488369"
    },
    {
      "job": 78843883177,
      "time": 184,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "7330484735"
    },
    {
      "job": 78843883102,
      "time": 193,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7330487846"
    }
  ],
  "_buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/imsmwu/rclickhouse",
  "_commit": {
    "id": "1a54f1a34d31936565a3dddc1825e866e36c0188",
    "author": "Christian Hotz-Behofsits <chris.hotz.behofsits@gmail.com>",
    "committer": "Christian Hotz-Behofsits <chris.hotz.behofsits@gmail.com>",
    "message": "Has been accepted and should be back on CRAN soon. (closes #112)\n",
    "time": 1740617571
  },
  "_maintainer": {
    "name": "Christian Hotz-Behofsits",
    "email": "christian.hotz-behofsits@wu.ac.at",
    "login": "inkrement",
    "twitter": "@inkrement",
    "description": "Assistent professor @ WU Vienna. Background in software & information engineering; now quantitative marketing.",
    "uuid": 604528
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.6.2",
      "role": "Depends"
    },
    {
      "package": "Rcpp",
      "role": "LinkingTo"
    },
    {
      "package": "dplyr",
      "version": ">= 1.1.0",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "version": ">= 2.0.0",
      "role": "Imports"
    },
    {
      "package": "methods",
      "version": ">= 3.3.2",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "version": ">= 1.0.0",
      "role": "Imports"
    },
    {
      "package": "Rcpp",
      "version": ">= 0.11.0",
      "role": "Imports"
    },
    {
      "package": "bit64",
      "role": "Imports"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    }
  ],
  "_owner": "imsmwu",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_topics": [
    "clickhouse",
    "clickhouse-database",
    "dbi-interface",
    "dplyr",
    "dplyr-sql-backends",
    "cpp"
  ],
  "_stars": 96,
  "_contributors": [
    {
      "user": "inkrement",
      "count": 198,
      "uuid": 604528
    },
    {
      "user": "artpaul",
      "count": 147,
      "uuid": 1533100
    },
    {
      "user": "v5r",
      "count": 109,
      "uuid": 4190036
    },
    {
      "user": "dwinkler1",
      "count": 32,
      "uuid": 22460147
    },
    {
      "user": "tridelt",
      "count": 26,
      "uuid": 24197322
    },
    {
      "user": "alexey-milovidov",
      "count": 16,
      "uuid": 18581488
    },
    {
      "user": "abyss7",
      "count": 11,
      "uuid": 5627721
    },
    {
      "user": "sistema987",
      "count": 8,
      "uuid": 234894230
    },
    {
      "user": "enmk",
      "count": 5,
      "uuid": 1110183
    },
    {
      "user": "filimonov",
      "count": 4,
      "uuid": 1549571
    },
    {
      "user": "krlmlr",
      "count": 4,
      "uuid": 1741643
    },
    {
      "user": "ciberst",
      "count": 4,
      "uuid": 11655210
    },
    {
      "user": "adubovikov",
      "count": 3,
      "uuid": 4513061
    },
    {
      "user": "pavel-odintsov",
      "count": 3,
      "uuid": 2744166
    },
    {
      "user": "clrusby",
      "count": 3,
      "uuid": 28167577
    },
    {
      "user": "dariayudaeva",
      "count": 3,
      "uuid": 98695842
    },
    {
      "user": "aiwhj",
      "count": 2,
      "uuid": 16408168
    },
    {
      "user": "mkyhos",
      "count": 2,
      "uuid": 33769439
    },
    {
      "user": "huaijiang",
      "count": 2,
      "uuid": 1789093
    },
    {
      "user": "cyfdecyf",
      "count": 2,
      "uuid": 344294
    },
    {
      "user": "alicjagrzadziel",
      "count": 1,
      "uuid": 39812189
    },
    {
      "user": "brick0",
      "count": 1,
      "uuid": 3419726
    },
    {
      "user": "xomachine",
      "count": 1,
      "uuid": 3051015
    },
    {
      "user": "hatarist",
      "count": 1,
      "uuid": 2741725
    },
    {
      "user": "blinkov",
      "count": 1,
      "uuid": 623861
    },
    {
      "user": "testtridelt",
      "count": 1,
      "uuid": 71324785
    },
    {
      "user": "alex-zaitsev",
      "count": 1,
      "uuid": 25770686
    },
    {
      "user": "dgrr",
      "count": 1,
      "uuid": 10146748
    },
    {
      "user": "lzmhhh123",
      "count": 1,
      "uuid": 26040259
    },
    {
      "user": "njlr",
      "count": 1,
      "uuid": 1577531
    },
    {
      "user": "ingvaror",
      "count": 1,
      "uuid": 162822457
    }
  ],
  "_userbio": {
    "uuid": 15648815,
    "type": "organization",
    "name": "IMSM WU Vienna",
    "description": "Institute for Interactive Marketing and Social Media"
  },
  "_downloads": {
    "count": 2362,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/RClickhouse"
  },
  "_devurl": "https://github.com/imsmwu/rclickhouse",
  "_searchresults": 22,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/RClickhouse.html",
    "manual.pdf"
  ],
  "_homeurl": "https://github.com/imsmwu/rclickhouse",
  "_realowner": "imsmwu",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.3.0",
      "date": "2017-11-26"
    },
    {
      "version": "0.4.0",
      "date": "2018-01-20"
    },
    {
      "version": "0.5",
      "date": "2020-01-29"
    },
    {
      "version": "0.5.1",
      "date": "2020-01-30"
    },
    {
      "version": "0.5.2",
      "date": "2020-03-06"
    },
    {
      "version": "0.6.0",
      "date": "2022-01-13"
    },
    {
      "version": "0.6.3",
      "date": "2022-03-08"
    },
    {
      "version": "0.6.4",
      "date": "2022-06-12"
    },
    {
      "version": "0.6.7",
      "date": "2023-04-02"
    },
    {
      "version": "0.6.8",
      "date": "2023-08-21"
    },
    {
      "version": "0.6.9",
      "date": "2024-01-19"
    },
    {
      "version": "0.6.10",
      "date": "2025-02-26"
    }
  ],
  "_exports": [
    "clickhouse",
    "dbBegin",
    "dbClearResult",
    "dbColumnInfo",
    "dbCommit",
    "dbConnect",
    "dbDataType",
    "dbDisconnect",
    "dbExistsTable",
    "dbFetch",
    "dbGetInfo",
    "dbGetRowCount",
    "dbGetRowsAffected",
    "dbGetStatement",
    "dbHasCompleted",
    "dbIsValid",
    "dbListFields",
    "dbListTables",
    "dbplyr_case_sensitive",
    "dbQuoteIdentifier",
    "dbQuoteString",
    "dbReadTable",
    "dbRemoveTable",
    "dbRollback",
    "dbSendQuery",
    "dbUnloadDriver",
    "fix_dbplyr",
    "loadConfig",
    "show"
  ],
  "_help": [
    {
      "page": "dbplyr_case_sensitive",
      "title": "Get dbplyr to work with Clickhouse",
      "topics": [
        "dbplyr_case_sensitive"
      ]
    },
    {
      "page": "fix_dbplyr",
      "title": "Return to dbplyrs original behavior",
      "topics": [
        "fix_dbplyr"
      ]
    },
    {
      "page": "RClickhouse",
      "title": "RClickhouse",
      "topics": [
        "RClickhouse-package",
        "RClickhouse"
      ]
    },
    {
      "page": "sql_variant",
      "title": "adapted from dbplyr",
      "topics": [
        "sql_aggregate",
        "sql_aggregate_2"
      ]
    }
  ],
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "DBI",
    "dbplyr",
    "dplyr",
    "generics",
    "glue",
    "lifecycle",
    "magrittr",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_sysdeps": [
    {
      "shlib": "libstdc++",
      "package": "libstdc++6",
      "source": "gcc",
      "version": "14.2.0-4ubuntu2~24.04.1",
      "name": "c++",
      "homepage": "http://gcc.gnu.org/",
      "description": "GNU Standard C++ Library v3"
    }
  ],
  "_score": 6.175095061858933,
  "_indexed": true,
  "_nocasepkg": "rclickhouse",
  "_universes": [
    "imsmwu",
    "inkrement"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.6.10",
      "date": "2026-06-01T11:39:24.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "d4a5b66c265a1277122dfb4a667718a1c7b1303775de5ee560cf207841fba52b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.6.10",
      "date": "2026-06-01T11:39:13.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "36f56db4b6effe5c45a9cc30854a03cd9b8140b3c957d25f31207924b224ce9d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.6.10",
      "date": "2026-06-01T11:39:29.000Z",
      "distro": "noble",
      "arch": "aarch64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "85e12923eb7cb0d0c09a79621f3a5eb52aafe3a4f4b82630cd84e2948871f894",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.6.10",
      "date": "2026-06-01T11:39:12.000Z",
      "distro": "noble",
      "arch": "x86_64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "9e9551e97e5dd42b0d23e098ae9bca06c22dda4f5ee33369dc8833619d8e738b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.6.10",
      "date": "2026-06-01T11:39:34.000Z",
      "arch": "aarch64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "e38dde6726db1a1105cc7ba567698a74c2ea0cb2592b1d07e1f2c99bd07aa9fa",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.6.10",
      "date": "2026-06-01T11:42:14.000Z",
      "arch": "x86_64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "9bd5674cf63964613fe107ae2b12c86506ea0f8014a38d63751adfb410e52b23",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.6.10",
      "date": "2026-06-01T11:39:36.000Z",
      "arch": "aarch64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "daa3928c34fed3c0afcd54dc34b8d94bc14425587f3048ece21702dc55f5451b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.6.10",
      "date": "2026-06-01T11:40:15.000Z",
      "arch": "x86_64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "e25af8828853508e8eec2b4d780c6bfeee8ec90cb36631343289be95f440d408",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.6.10",
      "date": "2026-06-01T11:39:28.000Z",
      "arch": "emscripten",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "7eb362732fd1a27991dce3059aa560779b3b9c89041a40041503dab84fe05ac5",
      "status": "success",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.6.10",
      "date": "2026-06-01T11:38:47.000Z",
      "arch": "x86_64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "c34be27ba41ff34bf8fa8c9ba5d0ac8ca4578b0c467b7bd6d7abe77da9a31e17",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.6.10",
      "date": "2026-06-01T11:38:36.000Z",
      "arch": "x86_64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "aa3ad709a07dbd9dd1e0725515973e7bac9f10f9666deec821a1a2fb999d3932",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.6.10",
      "date": "2026-06-01T11:38:40.000Z",
      "arch": "x86_64",
      "commit": "1a54f1a34d31936565a3dddc1825e866e36c0188",
      "fileid": "14b311704dc51d88313d8f6ab3bdf920b23fc1d522b2a3a28937684758975b00",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/imsmwu/actions/runs/26752361100"
    }
  ]
}