Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Changing timezone in cassandra

Changing timezone in cassandra

Explorer

Hey,

I am working on cassandra 3.0 and I am struck at how to change the default time zone in cassandra. Default is Greenwich time or UTC or +00:00 offset. I need to convert the default time to another timezone. I tried many sources and I am not able to figure it out.

For example: When doing a query like this: "select * from table WHERE time > 11:00 (HH:mm) AND time < 15"

The result is: all times between 11:00 and 13:00 which is wrong. The result has to be 12:00, 13:00 and 14:00.

My actual time zone is +01:00.

Thanks in advance.

2 REPLIES 2
Highlighted

Re: Changing timezone in cassandra

Explorer

Fixed this problem by creating and using the cqlshrc file like this:

http://docs.datastax.com/en/cql/3.1/cql/cql_reference/cqlshrc.html#clqshrc__cqlshrcOptions

I used "CET" for my timezone and it works so far.

Highlighted

Re: Changing timezone in cassandra

New Contributor

Hi @Salda Murrah,

Created cqlshrc file like that and moved it to .cassandra folder.

Changed "Display Timezone" parameter to "Europe/Minsk" and "UTC+3" but still, its not working.

What should i do?

,

Hi @Salda Murrah

I could not figure it how you solved this.

I changed timezone parameter to "UTC+3" in cqlshrc but still its not working.

Should i change datetimeformat?

All i need is to change it to UTC+3 since C* uses UTC by default.

Can you help me with that?

Don't have an account?
Coming from Hortonworks? Activate your account here