Skip to content

Instantly share code, notes, and snippets.

View lxynov's full-sized avatar

Xingyuan Lin lxynov

19 followers · 31 following
  • Celonis
  • New York
  • 18:06 (UTC -04:00)
View GitHub Profile
@lxynov
lxynov / FAQ.md
Created January 27, 2025 17:55 — forked from ngxson/FAQ.md
convert ARM NEON to WASM SIMD prompt

What is your setup?

Just chat.deepseek.com with prompts adapted from this gist.

Does it work in one-shot or I have to prompt it multiple times?

  • For the qX_0 variants, they are actually quite straight-forward so deepseek can come up with a correct result in 1 shot. It is already crazy enough, given that ChatGPT and Claude have never produced a working result for me.
  • For the qX_K it's more complicated, I would say most of the time I need to re-prompt it 4 to 8 more times.
  • The most difficult was q6_K, the code never works until I ask it to only optimize one specific part, while leaving the rest intact (so it does not mess up everything)
@lxynov
lxynov / copy.sql
Created April 7, 2022 21:29
Copying TPCDS tables to Iceberg
CREATE TABLE IF NOT EXISTS iceberg.tpcds_sf100000.call_center AS SELECT cc_call_center_sk, CAST (cc_call_center_id AS VARCHAR) cc_call_center_id, cc_rec_start_date, cc_rec_end_date, cc_closed_date_sk, cc_open_date_sk, cc_name, cc_class, cc_employees, cc_sq_ft, CAST (cc_hours AS VARCHAR) cc_hours, cc_manager, cc_mkt_id, CAST (cc_mkt_class AS VARCHAR) cc_mkt_class, cc_mkt_desc, cc_market_manager, cc_division, cc_division_name, cc_company, CAST (cc_company_name AS VARCHAR) cc_company_name, CAST (cc_street_number AS VARCHAR) cc_street_number, cc_street_name, CAST (cc_street_type AS VARCHAR) cc_street_type, CAST (cc_suite_number AS VARCHAR) cc_suite_number, cc_city, cc_county, CAST (cc_state AS VARCHAR) cc_state, CAST (cc_zip AS VARCHAR) cc_zip, cc_country, cc_gmt_offset, cc_tax_percentage FROM tpcds.sf100000.call_center
CREATE TABLE IF NOT EXISTS iceberg.tpcds_sf100000.catalog_page AS SELECT cp_catalog_page_sk, CAST (cp_catalog_page_id AS VARCHAR) cp_catalog_page_id, cp_start_date_sk, cp_end_date_sk, cp_departmen