I'm getting error D20432 while inserting a new row in a GridDB container using CLI

Question

I´m running GridDB on Windows WSL, with Ubuntu installed. Using the guidelines provided in this tutorial video from GridDB’s channel (https://www.youtube.com/watch?v=5bdc2UNLnj8), I created the following table using GridDB’s CLI:

createcollection customers id integer name string phone string email string

When I try to insert a row using putrow command below, I get the error “D20432: The number of specified column values is larger than that of the container.”

putrow customers 1 Danilo Silva 5729997091721 dan@if.edu.br

Any ideas?

Answer 1

Since putrow uses spaces as separators, it turns out that multi-part strings must be embedded in single quotes. So, the correct statement is:

putrow customers 1 'Danilo Silva' 5729997091721 dan@if.edu.br

tql customers select *;

1 results. (1 ms)

get

+----+--------------+---------------+---------------+

| id | name | phone | email |

+----+--------------+---------------+---------------+

| 1 | Danilo Silva | 5729997091721 | dan@if.edu.br |

+----+--------------+---------------+---------------+

The 1 results had been acquired.