framework/resources/Functional/text_storage/testcases/selectpart.sql

select columns[0],
columns[1],
columns[4],
columns[10],
columns[13]
from `/drill/testdata/text_storage/lineitempart` where dir0=1993;