Please
UseCodeTags when posting code in the forums....
At first step, Athena creates a database and at second step it initializes the metadata. I am getting this Error while Athena framework tries to initialize the meta-data for the database. So, I am having hard time to find out which particular SQL is giving me this error.
I haven't use this particular framework though. But I think there must (most probably) be a way that you can inspect the generated SQL by the framework (by logging/tracing etc...). Have you checked the documentation for this? There even might be some compatible versions of RDBMS of each vendor for different versions of the framework.
I am trying to de-compile all the Athena jar files and looking at the code but it is really testing me out...
You can see them for academic purpose of course. But I don't think it would help solving this kind of problem (unless its not properly documented and you might get some tips by looking at the source, but most people would not use that kind of library anyway). Because you can't easily change a framework like this. Looking at the code it's hard to tell anything because it depends on many utility methods/configuration files etc... Best option would be look at the documentation or any other guide(s) available. It should tell you how to set the values and what to expect.