In Impala, I used the select now() query to get the current timestamp and add_months(now(), 2) to add months to the timestamp. My question is, how can I subtract the month from the timestamp? I could not find any subtract_months() method. Please help.
You don't need another method, you can use the add_months method with a negative value to subtract month. You can try something like this:
select now(), add_months(now(), -1);
Impala provides faster response as it uses MPP(massively ...READ MORE
Read operation on HDFS
In order to read ...READ MORE
The MongoDB Connector for Hadoop reads data ...READ MORE
Yes, you heard it correctly.
Apache Sqoop is ...READ MORE
Firstly you need to understand the concept ...READ MORE
org.apache.hadoop.mapred is the Old API
org.apache.hadoop.mapreduce is the ...READ MORE
put <localSrc> <dest>
copyFr ...READ MORE
In your case there is no difference ...READ MORE
To load data from HDFS to pig ...READ MORE
Nothing to worry about creating any file ...READ MORE
Already have an account? Sign in.