inserts in ClickHouse database
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
currently I'm using ClickHouse database and I have some trouble in inserting data to database. Question: how to insert data from file(insert script) in ClickHouse database
database clickhouse
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
add a comment |
currently I'm using ClickHouse database and I have some trouble in inserting data to database. Question: how to insert data from file(insert script) in ClickHouse database
database clickhouse
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
I literally pasted your question into google and got this: clickhouse.yandex/docs/en/operations/table_engines/… i hope it helps. If not you can always tell us what you've tried in your post.
– Sebastian L
Nov 14 '18 at 7:18
@SebastianL thank you, I will try
– Eduard Pelivan
Nov 14 '18 at 8:50
add a comment |
currently I'm using ClickHouse database and I have some trouble in inserting data to database. Question: how to insert data from file(insert script) in ClickHouse database
database clickhouse
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
currently I'm using ClickHouse database and I have some trouble in inserting data to database. Question: how to insert data from file(insert script) in ClickHouse database
database clickhouse
database clickhouse
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
asked Nov 14 '18 at 7:10
Eduard PelivanEduard Pelivan
1
1
I literally pasted your question into google and got this: clickhouse.yandex/docs/en/operations/table_engines/… i hope it helps. If not you can always tell us what you've tried in your post.
– Sebastian L
Nov 14 '18 at 7:18
@SebastianL thank you, I will try
– Eduard Pelivan
Nov 14 '18 at 8:50
add a comment |
I literally pasted your question into google and got this: clickhouse.yandex/docs/en/operations/table_engines/… i hope it helps. If not you can always tell us what you've tried in your post.
– Sebastian L
Nov 14 '18 at 7:18
@SebastianL thank you, I will try
– Eduard Pelivan
Nov 14 '18 at 8:50
I literally pasted your question into google and got this: clickhouse.yandex/docs/en/operations/table_engines/… i hope it helps. If not you can always tell us what you've tried in your post.
– Sebastian L
Nov 14 '18 at 7:18
I literally pasted your question into google and got this: clickhouse.yandex/docs/en/operations/table_engines/… i hope it helps. If not you can always tell us what you've tried in your post.
– Sebastian L
Nov 14 '18 at 7:18
@SebastianL thank you, I will try
– Eduard Pelivan
Nov 14 '18 at 8:50
@SebastianL thank you, I will try
– Eduard Pelivan
Nov 14 '18 at 8:50
add a comment |
1 Answer
1
active
oldest
votes
With clickhouse-client:
cat data.csv | clickhouse-client --query="INSERT INTO data FORMAT CSV";
Or via http interface
cat data.csv | curl http://localhost:8123/?query=INSERT%20INTO%20default.data%20FORMAT%20CSV' --data-binary @-
For the POST requests, you can pass your data directly in request body which is more suitable for large datasets.
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53294821%2finserts-in-clickhouse-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
With clickhouse-client:
cat data.csv | clickhouse-client --query="INSERT INTO data FORMAT CSV";
Or via http interface
cat data.csv | curl http://localhost:8123/?query=INSERT%20INTO%20default.data%20FORMAT%20CSV' --data-binary @-
For the POST requests, you can pass your data directly in request body which is more suitable for large datasets.
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
add a comment |
With clickhouse-client:
cat data.csv | clickhouse-client --query="INSERT INTO data FORMAT CSV";
Or via http interface
cat data.csv | curl http://localhost:8123/?query=INSERT%20INTO%20default.data%20FORMAT%20CSV' --data-binary @-
For the POST requests, you can pass your data directly in request body which is more suitable for large datasets.
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
add a comment |
With clickhouse-client:
cat data.csv | clickhouse-client --query="INSERT INTO data FORMAT CSV";
Or via http interface
cat data.csv | curl http://localhost:8123/?query=INSERT%20INTO%20default.data%20FORMAT%20CSV' --data-binary @-
For the POST requests, you can pass your data directly in request body which is more suitable for large datasets.
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
With clickhouse-client:
cat data.csv | clickhouse-client --query="INSERT INTO data FORMAT CSV";
Or via http interface
cat data.csv | curl http://localhost:8123/?query=INSERT%20INTO%20default.data%20FORMAT%20CSV' --data-binary @-
For the POST requests, you can pass your data directly in request body which is more suitable for large datasets.
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
answered Nov 18 '18 at 13:38
simPodsimPod
2,756104385
2,756104385
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53294821%2finserts-in-clickhouse-database%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I literally pasted your question into google and got this: clickhouse.yandex/docs/en/operations/table_engines/… i hope it helps. If not you can always tell us what you've tried in your post.
– Sebastian L
Nov 14 '18 at 7:18
@SebastianL thank you, I will try
– Eduard Pelivan
Nov 14 '18 at 8:50