AWS Athena: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
(Created page with "from the light sensor data project: <pre> CREATE EXTERNAL TABLE IF NOT EXISTS lightsensordb.sensordatatable ( `timestamp` int, `reading1` float, `reading2` float ) ROW...") |
No edit summary |
||
| Line 16: | Line 16: | ||
TBLPROPERTIES ('has_encrypted_data'='false'); | TBLPROPERTIES ('has_encrypted_data'='false'); | ||
</pre> | </pre> | ||
SELECT timestamp , reading1, reading2 from lightsensordb.sensordatatable LIMIT 100 | |||
Revision as of 19:07, 19 March 2018
from the light sensor data project:
CREATE EXTERNAL TABLE IF NOT EXISTS lightsensordb.sensordatatable (
`timestamp` int,
`reading1` float,
`reading2` float
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'serialization.format' = ' ',
'field.delim' = ' ',
'collection.delim' = 'undefined',
'mapkey.delim' = 'undefined'
) LOCATION 's3://mymainsqueeze/sensor/'
TBLPROPERTIES ('has_encrypted_data'='false');
SELECT timestamp , reading1, reading2 from lightsensordb.sensordatatable LIMIT 100
