New Contributor
Posts: 1
Registered: ‎05-22-2018

Impala data reduction based on time value

I'm looking for a solution to restrict my data table based on year. What is the correct syntax for achieving this?


SELECT [column] FROM database IN('yyyy')


Help please :) 

Expert Contributor
Posts: 136
Registered: ‎07-17-2017

Re: Impala data reduction based on time value

Hi @Kath,

What the type of the column you want to restrict it? is it a TIMESTAMP column?
If it's a TIMESTAMP or STRING try to use this:

select [column] from [table] where extract(year from [column]) is not null;

Good luck.


Our community is getting a little larger. And a lot better.

Learn More about the Cloudera and Hortonworks community merger planned for late July and early August.