Does drill have something analogous to SQL CONSTRAINT and REFERENCES for doing table type lookups?
I have a large data that uses numerical ISO country codes; they need to be replaced with country names that are mapped in a small CSV file (iso_code, country_name). Any suggestions? Thanks you, Peder P.S. Is it worth learning Pig Latin or something similar for more complex queries and data manipulation in Drill?
