Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Actually U-SQL gives you the ability to map files to a virtual table (aka view :)).

CREATE VIEW V AS EXTRACT <insert schema here> FROM "/a/b/{*}.csv" USING Extractors.Csv();

If the data is more complex, you can write your own Extractors that for example handle the divergence in columns. Although we are planning on some features here in the future.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: