search

citusdata / citus_docs

Documentation for Citus. Distributed PostgreSQL as an extension.
Creative Commons Attribution 4.0 International
58 stars 59 forks source link

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

Open gurkanindibay opened 2 years ago

gurkanindibay commented 2 years ago

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

jonels-msft commented 2 years ago

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.

onderkalaci commented 2 years ago

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