Issue on docs [Create database and test table]

Open Beginner friendly
#3,304 3 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
1/5
Estimated time
Under an hour
Newbie friendliness
68/100
Issue type
Documentation
Clarity
Clearly specified
Activity status
Quiet
Tech stack
sql
Domain
databases, documentation

Research direction

Open docs/4.x/gettingStarted/quick-start and find the database and test-table example. Update the CREATE TABLE example to include the replication_num property set to 1, then verify that the instructions work when only one backend is available.

Written by the indexing model from the issue text.

Description

Path:/docs/4.x/gettingStarted/quick-start

SQL Error [1105] [HY000]: errCode = 2, detailMessage = replication num should be less than the number of available backends. replication num is 3, available backend num is 1

create database demo;

use demo;
create table mytable
(
k1 TINYINT,
k2 DECIMAL(10, 2) DEFAULT "10.05",
k3 CHAR(10) COMMENT "string column",
k4 INT NOT NULL DEFAULT "1" COMMENT "int column"
)
COMMENT "my first table"
DISTRIBUTED BY HASH(k1) BUCKETS 1;

should be

CREATE TABLE mytable (
k1 TINYINT,
k2 DECIMAL(10, 2) DEFAULT "10.05",
k3 CHAR(10) COMMENT "string column",
k4 INT NOT NULL DEFAULT "1" COMMENT "int column"
)
COMMENT "my first table"
DISTRIBUTED BY HASH(k1) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);

Dominant language
MDX
Stars
134
Forks
466
Avg merge
1d 11h
Merged PRs (30d)
54

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from apache/doris-website

All issues in apache/doris-website

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.