Create sameple table hashing on year(l_shipdate)?

verdict-project / verdict

Interactive-Speed Analytics: 200x Faster, 200x Fewer Cluster Resources, Approximate Query Processing

http://verdictdb.org

Apache License 2.0

248 stars 66 forks source link

Closed hychen20 closed 5 years ago

hychen20 commented 5 years ago

I'm trying to test VerdictDB using TPC-H. However, I was wondering if I can create a sample table hashing on an expression of a column? For example,

CREATE SCRAMBLE tpch1g.lineitem_scramble FROM tpch1g.lineitem HASH ON year(l_shipdate) BLOCKSIZE 100

dongyoungy commented 5 years ago

Hash scrambling only supports hashing on a column currently.

hychen20 commented 5 years ago

How about multiple columns?

dongyoungy commented 5 years ago

It only works on a single column at the moment.

hychen20 commented 5 years ago

Got it! Thanks!