This is an automated email from the ASF dual-hosted git repository.
achennaka pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/kudu-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new bb6d1bef Publish commit(s) from site source repo: a71b5b5 [blog] Fix
typo in blogpost
bb6d1bef is described below
commit bb6d1bef3d33b7f97b4be5bb10602faff466ce91
Author: root <[email protected]>
AuthorDate: Tue May 7 12:20:29 2024 -0700
Publish commit(s) from site source repo:
a71b5b5 [blog] Fix typo in blogpost
Site-Repo-Commit: a71b5b54c81d935ae01ce033aa07e33677aeeabb
---
2024/03/07/introducing-auto-incrementing-column.html | 13 ++++++-------
feed.xml | 15 +++++++--------
2 files changed, 13 insertions(+), 15 deletions(-)
diff --git a/2024/03/07/introducing-auto-incrementing-column.html
b/2024/03/07/introducing-auto-incrementing-column.html
index 98b465ec..a7c471c0 100644
--- a/2024/03/07/introducing-auto-incrementing-column.html
+++ b/2024/03/07/introducing-auto-incrementing-column.html
@@ -170,7 +170,6 @@ SELECT *, auto_incrementing_id FROM <tablename></p>
<h4 id="examples">Examples</h4>
<p>Create a table with two columns and two hash partitions:</p>
-
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>default> CREATE TABLE demo_table(id INT NON UNIQUE
PRIMARY KEY, name STRING) PARTITION BY HASH (id) PARTITIONS 2 STORED AS KUDU;
Query: CREATE TABLE demo_table(id INT NON UNIQUE PRIMARY KEY, name STRING)
PARTITION BY HASH (id) PARTITIONS 2 STORED AS KUDU
+-------------------------+
@@ -182,7 +181,6 @@ Fetched 1 row(s) in 3.94s
</code></pre></div></div>
<p>Describe the table:</p>
-
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>default> DESCRIBE demo_table;
Query: DESCRIBE demo_table
+----------------------+--------+---------+-------------+------------+----------+---------------+---------------+---------------------+------------+
@@ -194,15 +192,14 @@ Query: DESCRIBE demo_table
+----------------------+--------+---------+-------------+------------+----------+---------------+---------------+---------------------+------------+
</code></pre></div></div>
-<p><br />Insert rows with duplicate partial primary key column values:</p>
-
+<p>Insert rows with duplicate partial primary key column values:</p>
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>default> INSERT INTO demo_table VALUES (1, 'John'),
(2, 'Bob'), (3, 'Mary'), (1, 'Joe');
Query: INSERT INTO demo_table VALUES (1, 'John'), (2, 'Bob'), (3, 'Mary'), (1,
'Joe')
..
Modified 4 row(s), 0 row error(s) in 0.41s
</code></pre></div></div>
-<p><br />Scan the table (notice the duplicate values in the ‘id’ column):</p>
+<p>Scan the table (notice the duplicate values in the ‘id’ column):</p>
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>default> SELECT * FROM demo_table;
Query: SELECT * FROM demo_table
..
@@ -243,6 +240,7 @@ default> DELETE FROM demo_table where id=2;
Query: DELETE FROM demo_table where id=2;
Modified 1 row(s), 0 row error(s) in 1.40s
</code></pre></div></div>
+
<p>Scan all the columns of the table:</p>
<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code>default> SELECT *, auto_incrementing_id FROM
demo_table;
Query: SELECT *, auto_incrementing_id FROM demo_table
@@ -256,12 +254,13 @@ Query: SELECT *, auto_incrementing_id FROM demo_table
+----+------+----------------------+
Fetched 3 row(s) in 0.20s
</code></pre></div></div>
+
<h4 id="limitations">Limitations</h4>
<p>Impala doesn’t support UPSERT operations on tables with the
auto-incrementing column as of writing
this article.</p>
-<h3 id="kudu-clientsjava-c-python">Kudu clients(Java, C++, Python)</h3>
+<h3 id="kudu-clients-java-c-python">Kudu clients (Java, C++, Python)</h3>
<p>Unlike in Impala, scanning the table fetches all the table data including
the auto incrementing column.
There is no need to explicitly request the auto-incrementing column.</p>
@@ -276,7 +275,7 @@ regular UPDATE operation. If the row is not present, it is
considered an INSERT
<p><a
href="https://github.com/apache/kudu/blob/master/examples/python/basic-python-example/non_unique_primary_key.py";>https://github.com/apache/kudu/blob/master/examples/python/basic-python-example/non_unique_primary_key.py</a></p>
-<p>##Backup and Restore</p>
+<h2 id="backup-and-restore">Backup and Restore</h2>
<p>The Kudu backup tool from Kudu 1.17 and later supports backing up tables
with the
auto-incrementing column. The prior backup tools will fail with an error
message -
diff --git a/feed.xml b/feed.xml
index 07cb02de..937c9488 100644
--- a/feed.xml
+++ b/feed.xml
@@ -1,4 +1,4 @@
-<?xml version="1.0" encoding="utf-8"?><feed
xmlns="http://www.w3.org/2005/Atom"; ><generator uri="https://jekyllrb.com/";
version="4.1.1">Jekyll</generator><link href="/feed.xml" rel="self"
type="application/atom+xml" /><link href="/" rel="alternate" type="text/html"
/><updated>2024-04-30T10:59:16-07:00</updated><id>/feed.xml</id><entry><title
type="html">Introducing Auto-incrementing Column in Kudu</title><link
href="/2024/03/07/introducing-auto-incrementing-column.html" rel="alternate" t
[...]
+<?xml version="1.0" encoding="utf-8"?><feed
xmlns="http://www.w3.org/2005/Atom"; ><generator uri="https://jekyllrb.com/";
version="4.1.1">Jekyll</generator><link href="/feed.xml" rel="self"
type="application/atom+xml" /><link href="/" rel="alternate" type="text/html"
/><updated>2024-05-07T12:20:23-07:00</updated><id>/feed.xml</id><entry><title
type="html">Introducing Auto-incrementing Column in Kudu</title><link
href="/2024/03/07/introducing-auto-incrementing-column.html" rel="alternate" t
[...]
<h1 id="introduction">Introduction</h1>
@@ -48,7 +48,6 @@ SELECT *, auto_incrementing_id FROM
&lt;tablename&gt;</p>
<h4 id="examples">Examples</h4>
<p>Create a table with two columns and two hash partitions:</p>
-
<div class="language-plaintext highlighter-rouge"><div
class="highlight"><pre
class="highlight"><code>default&gt; CREATE TABLE
demo_table(id INT NON UNIQUE PRIMARY KEY, name STRING) PARTITION BY HASH (id)
PARTITIONS 2 STORED AS KUDU;
Query: CREATE TABLE demo_table(id INT NON UNIQUE PRIMARY KEY, name STRING)
PARTITION BY HASH (id) PARTITIONS 2 STORED AS KUDU
+-------------------------+
@@ -60,7 +59,6 @@ Fetched 1 row(s) in 3.94s
</code></pre></div></div>
<p>Describe the table:</p>
-
<div class="language-plaintext highlighter-rouge"><div
class="highlight"><pre
class="highlight"><code>default&gt; DESCRIBE demo_table;
Query: DESCRIBE demo_table
+----------------------+--------+---------+-------------+------------+----------+---------------+---------------+---------------------+------------+
@@ -72,15 +70,14 @@ Query: DESCRIBE demo_table
+----------------------+--------+---------+-------------+------------+----------+---------------+---------------+---------------------+------------+
</code></pre></div></div>
-<p><br />Insert rows with duplicate partial primary key column
values:</p>
-
+<p>Insert rows with duplicate partial primary key column
values:</p>
<div class="language-plaintext highlighter-rouge"><div
class="highlight"><pre
class="highlight"><code>default&gt; INSERT INTO
demo_table VALUES (1, 'John'), (2, 'Bob'), (3, 'Mary'), (1, 'Joe');
Query: INSERT INTO demo_table VALUES (1, 'John'), (2, 'Bob'), (3, 'Mary'), (1,
'Joe')
..
Modified 4 row(s), 0 row error(s) in 0.41s
</code></pre></div></div>
-<p><br />Scan the table (notice the duplicate values in the ‘id’
column):</p>
+<p>Scan the table (notice the duplicate values in the ‘id’
column):</p>
<div class="language-plaintext highlighter-rouge"><div
class="highlight"><pre
class="highlight"><code>default&gt; SELECT * FROM
demo_table;
Query: SELECT * FROM demo_table
..
@@ -121,6 +118,7 @@ default&gt; DELETE FROM demo_table where id=2;
Query: DELETE FROM demo_table where id=2;
Modified 1 row(s), 0 row error(s) in 1.40s
</code></pre></div></div>
+
<p>Scan all the columns of the table:</p>
<div class="language-plaintext highlighter-rouge"><div
class="highlight"><pre
class="highlight"><code>default&gt; SELECT *,
auto_incrementing_id FROM demo_table;
Query: SELECT *, auto_incrementing_id FROM demo_table
@@ -134,12 +132,13 @@ Query: SELECT *, auto_incrementing_id FROM demo_table
+----+------+----------------------+
Fetched 3 row(s) in 0.20s
</code></pre></div></div>
+
<h4 id="limitations">Limitations</h4>
<p>Impala doesn’t support UPSERT operations on tables with the
auto-incrementing column as of writing
this article.</p>
-<h3 id="kudu-clientsjava-c-python">Kudu clients(Java, C++,
Python)</h3>
+<h3 id="kudu-clients-java-c-python">Kudu clients (Java, C++,
Python)</h3>
<p>Unlike in Impala, scanning the table fetches all the table data
including the auto incrementing column.
There is no need to explicitly request the auto-incrementing column.</p>
@@ -154,7 +153,7 @@ regular UPDATE operation. If the row is not present, it is
considered an INSERT
<p><a
href="https://github.com/apache/kudu/blob/master/examples/python/basic-python-example/non_unique_primary_key.py">https://github.com/apache/kudu/blob/master/examples/python/basic-python-example/non_unique_primary_key.py</a></p>
-<p>##Backup and Restore</p>
+<h2 id="backup-and-restore">Backup and Restore</h2>
<p>The Kudu backup tool from Kudu 1.17 and later supports backing up
tables with the
auto-incrementing column. The prior backup tools will fail with an error
message -
