clickhouse table creation error in ubuntu

Question

I installed the clickhouse program in the ubuntu operating system and connected the SQLyog program. I can create a database, but I cannot create a table in it. It gives the following CODE:119 error.

ubuntu :) create table taxonomy_object_firewalls

CREATE TABLE taxonomy_object_firewalls

Query id: 37520dd5-44b9-436f-a5b6-96002f0a4ce7

0 rows in set. Elapsed: 0.001 sec.

Received exception from server (version 22.2.2): Code: 119. DB::Exception: Received from localhost:9000. DB::Exception: Table engine is not specified in CREATE query. (ENGINE_REQUIRED)

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community, Feb 19 '23 at 14:39

score 0 · Answer 1 · answered Feb 19 '23 at 13:28

0

Check out the "Getting Started" guide in the docs. ClickHouse is unique in that every table has an Engine. Table engines determine where and how the data is stored. When in doubt, use MergeTree:

CREATE DATABASE IF NOT EXISTS helloworld;

CREATE TABLE helloworld.my_first_table
(
    user_id UInt32,
    message String,
    timestamp DateTime,
    metric Float32
)
ENGINE = MergeTree()
PRIMARY KEY (user_id, timestamp)

Also, make sure you read about the primary key and how it works in ClickHouse. Primary keys are not typically unique, but instead determine the sort order.

answered Feb 19 '23 at 13:28

Rich Raposa

190
4

I copied the example in the link you sent and created a table, but I still get an error. I cannot create a table. – recepyiyit Feb 19 '23 at 13:41
What error did you get? – Rich Raposa Feb 19 '23 at 14:10
now i also tried to add a different table and i am facing this issue – recepyiyit Feb 19 '23 at 17:24
Code: 50. DB::Exception: Received from 127.0.0.1:9000. DB::Exception: Unknown data type family: StringL. Maybe you meant: ['String','SINGLE']. (UNKNOWN_TYPE) – recepyiyit Feb 19 '23 at 17:24
StringL is not a data type - probably just a typo. Use String. – Rich Raposa Feb 19 '23 at 18:07
I'll look into it and reply back thanks. – recepyiyit Feb 19 '23 at 20:27

score 0 · Accepted Answer · answered Feb 19 '23 at 16:39

Noting that Rich's syntax had a small unnecessary () after the ENGINE definition but was still successfully created in my testing. This syntax would be more accurate to the documentation:

CREATE DATABASE IF NOT EXISTS helloworld;

CREATE TABLE helloworld.my_first_table
(
    user_id UInt32,
    message String,
    timestamp DateTime,
    metric Float32
)
ENGINE = MergeTree
PRIMARY KEY (user_id, timestamp);

clickhouse table creation error in ubuntu

2 Answers2

Linked