I have just started learning AWS Athena through an online course and have been following it up with the official aws documentation. I understand that Athena uses the Hive as an underlying mechanism to issue ddl queries, so it is basically the Hive syntax which we use.
From their documentation, I have trouble understanding these things :
- [COMMENT table_comment] Creates the comment table property and populates it with the table_comment you specify.
What is the comment table property and how does it helps us ? do we have any specific usage of this
- [STORED AS file_format]
Specifies the file format for table data . By specifying this we would instruct how the data obtained from querying a resource should be saved in the output s3 file
But for this option, specifically
INPUTFORMAT input_format_classname OUTPUTFORMAT output_format_classname
from where would we get the input_format_classname and output_format_classname ?
Any leads to an alternative reference or documentation would be appreciated :)
Top comments (0)