citus_docs icon indicating copy to clipboard operation
citus_docs copied to clipboard

Getting error while loading example data in estimating-topn-items

Open gurkanindibay opened this issue 4 years ago • 2 comments

When exeuting command command below in the address https://docs.citusdata.com/en/v10.2/develop/reference_sql.html#estimating-top-n-items, I'm getting an error

curl -L https://examples.citusdata.com/customer_reviews_2000.csv.gz | \ gunzip > reviews.csv

Error image

gurkanindibay avatar Jan 07 '22 16:01 gurkanindibay

Thanks for reporting this.

Do you think this is a docs issue, or a problem in https://github.com/citusdata/docker ? Might be worth opening an issue there.

jonels-msft avatar Jan 07 '22 16:01 jonels-msft

This works on my local non-docker environment. The table would be 293MB. I wonder if this is somehow disk storage limit or anything related to disk size on your environment?

 \COPY customer_reviews FROM 'reviews.csv' WITH CSV
COPY 1260658
Time: 11938.502 ms (00:11.939)


 onderkalaci@postgres:5432-12824=# select * from citus_tables;
    table_name    | citus_table_type | distribution_column | colocation_id | table_size | shard_count | table_owner | access_method 
------------------+------------------+---------------------+---------------+------------+-------------+-------------+---------------
 customer_reviews | distributed      | product_id          |             3 | 293 MB     |          32 | onderkalaci | heap

onderkalaci avatar Jan 10 '22 08:01 onderkalaci