Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Running Q1 lineitem throws http -1 error. #103

Open
Tmonster opened this issue Feb 17, 2025 · 0 comments
Open

Running Q1 lineitem throws http -1 error. #103

Tmonster opened this issue Feb 17, 2025 · 0 comments

Comments

@Tmonster
Copy link
Contributor

Have a copy of lineitem sf=1 on a data lake formation table bucket. However, when trying to run the query, I got the following unhelpful error.
Logging this here so we remember to look into it

D CREATE SECRET (
      TYPE ICEBERG,
      ENDPOINT 'XXXXX',
      AWS_REGION 'us-east-1'
    );
┌─────────┐
│ Success │
│ boolean │
├─────────┤
│ true    │
└─────────┘
D  ATTACH 'XXXXX' AS my_datalake (TYPE ICEBERG);
D show all tables;
100% ▕████████████████████████████████████████████████████████████▏
┌─────────────┬─────────────────┬───────────┬──────────────┬──────────────┬───────────┐
│  database   │     schema      │   name    │ column_names │ column_types │ temporary │
│   varchar   │     varchar     │  varchar  │  varchar[]   │  varchar[]   │  boolean  │
├─────────────┼─────────────────┼───────────┼──────────────┼──────────────┼───────────┤
│ my_datalake │ myblognamespace │ customers │ [__]         │ [INTEGER]    │ false     │
│ my_datalake │ myblognamespace │ lineitem  │ [__]         │ [INTEGER]    │ false     │
└─────────────┴─────────────────┴───────────┴──────────────┴──────────────┴───────────┘
D SELECT
      l_returnflag,
      l_linestatus,
      sum(l_quantity) AS sum_qty,
      sum(l_extendedprice) AS sum_base_price,
      sum(l_extendedprice * (1 - l_discount)) AS sum_disc_price,
      sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) AS sum_charge,
      avg(l_quantity) AS avg_qty,
      avg(l_extendedprice) AS avg_price,
      avg(l_discount) AS avg_disc,
      count(*) AS count_order
  FROM
      my_datalake.myblognamespace.lineitem
  WHERE
      l_shipdate <= CAST('1998-09-02' AS date)
  GROUP BY
      l_returnflag,
      l_linestatus
  ORDER BY
      l_returnflag,
      l_linestatus;
IO Error:
Failed to query https://glue.us-east-1.amazonaws.com/iceberg/v1/catalogs/840140254803:s3tablescatalog:pyiceberg-blog-bucket/namespaces/myblognamespace/tables/lineitem, http error -1 thrown
D select * from my_datalake.myblognamespace.lineitem limit 10;
100% ▕████████████████████████████████████████████████████████████▏
┌────────────┬───────────┬───────────┬──────────────┬───────────────┬───┬──────────────┬───────────────┬───────────────────┬────────────┬──────────────────────┐
│ l_orderkey │ l_partkey │ l_suppkey │ l_linenumber │  l_quantity   │ … │ l_commitdate │ l_receiptdate │  l_shipinstruct   │ l_shipmode │      l_comment       │
│   int64    │   int64   │   int64   │    int64     │ decimal(15,2) │   │     date     │     date      │      varchar      │  varchar   │       varchar        │
├────────────┼───────────┼───────────┼──────────────┼───────────────┼───┼──────────────┼───────────────┼───────────────────┼────────────┼──────────────────────┤
│          1 │    155190 │      7706 │            1 │         17.00 │ … │ 1996-02-12   │ 1996-03-22    │ DELIVER IN PERSON │ TRUCK      │ to beans x-ray car…  │
│          1 │     67310 │      7311 │            2 │         36.00 │ … │ 1996-02-28   │ 1996-04-20    │ TAKE BACK RETURN  │ MAIL       │  according to the …  │
│          1 │     63700 │      3701 │            3 │          8.00 │ … │ 1996-03-05   │ 1996-01-31    │ TAKE BACK RETURN  │ REG AIR    │ ourts cajole above…  │
│          1 │      2132 │      4633 │            4 │         28.00 │ … │ 1996-03-30   │ 1996-05-16    │ NONE              │ AIR        │ s cajole busily ab…  │
│          1 │     24027 │      1534 │            5 │         24.00 │ … │ 1996-03-14   │ 1996-04-01    │ NONE              │ FOB        │  the regular, regu…  │
│          1 │     15635 │       638 │            6 │         32.00 │ … │ 1996-02-07   │ 1996-02-03    │ DELIVER IN PERSON │ MAIL       │ rouches. special     │
│          2 │    106170 │      1191 │            1 │         38.00 │ … │ 1997-01-14   │ 1997-02-02    │ TAKE BACK RETURN  │ RAIL       │ re. enticingly reg…  │
│          3 │      4297 │      1798 │            1 │         45.00 │ … │ 1994-01-04   │ 1994-02-23    │ NONE              │ AIR        │ s cajole above the…  │
│          3 │     19036 │      6540 │            2 │         49.00 │ … │ 1993-12-20   │ 1993-11-24    │ TAKE BACK RETURN  │ RAIL       │ ecial pinto beans.…  │
│          3 │    128449 │      3474 │            3 │         27.00 │ … │ 1993-11-22   │ 1994-01-23    │ DELIVER IN PERSON │ SHIP       │ e carefully fina     │
├────────────┴───────────┴───────────┴──────────────┴───────────────┴───┴──────────────┴───────────────┴───────────────────┴────────────┴──────────────────────┤
│ 10 rows                                                                                                                                16 columns (10 shown) │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant