Writing Impala query results in a file

Question

I need to store the result of an Impala query in a text file with no other information but the data itself. For example: select distinct yrmth from test.abc It should write: 201705 201706 etc. in a text file line by line.

Any leads?

Possible duplicate of [Export as csv in beeline hive](https://stackoverflow.com/questions/39577036/export-as-csv-in-beeline-hive) — OneCricketeer, Dec 17 '17 at 19:10

score 2 · Accepted Answer · answered Dec 18 '17 at 03:47

2

impala-shell is well documented. You should try reading the help manual first. Anyway, here is your answer.

impala-shell -q 'select distinct yrmth from test.abc' -B -o res.txt

answered Dec 18 '17 at 03:47

Amos

3,040
3
15
37

Writing Impala query results in a file

1 Answers1