store_sales.txt.attr 1.3 KB

1234567891011121314151617181920212223242526272829
  1. {
  2. "_yql_row_spec"={
  3. "Type"=["StructType";[
  4. ["ss_sold_date_sk";["PgType";"int4";];];
  5. ["ss_sold_time_sk";["PgType";"int4";];];
  6. ["ss_item_sk";["PgType";"int4";];];
  7. ["ss_customer_sk";["PgType";"int4";];];
  8. ["ss_cdemo_sk";["PgType";"int4";];];
  9. ["ss_hdemo_sk";["PgType";"int4";];];
  10. ["ss_addr_sk";["PgType";"int4";];];
  11. ["ss_store_sk";["PgType";"int4";];];
  12. ["ss_promo_sk";["PgType";"int4";];];
  13. ["ss_ticket_number";["PgType";"int4";];];
  14. ["ss_quantity";["PgType";"int4";];];
  15. ["ss_wholesale_cost";["PgType";"numeric";];];
  16. ["ss_list_price";["PgType";"numeric";];];
  17. ["ss_sales_price";["PgType";"numeric";];];
  18. ["ss_ext_discount_amt";["PgType";"numeric";];];
  19. ["ss_ext_sales_price";["PgType";"numeric";];];
  20. ["ss_ext_wholesale_cost";["PgType";"numeric";];];
  21. ["ss_ext_list_price";["PgType";"numeric";];];
  22. ["ss_ext_tax";["PgType";"numeric";];];
  23. ["ss_coupon_amt";["PgType";"numeric";];];
  24. ["ss_net_paid";["PgType";"numeric";];];
  25. ["ss_net_paid_inc_tax";["PgType";"numeric";];];
  26. ["ss_net_profit";["PgType";"numeric";];];
  27. ];];
  28. }
  29. }