Open StuShepherdUK opened 4 years ago
From within R, am looking to perform the MSCK repair table to ensure the partitions are correct before downloading data.
Current script example:
library(AWR.Athena) Sys.setenv("AWS_ACCESS_KEY_ID" = "xxxxxxx", "AWS_SECRET_ACCESS_KEY" = "xxxxxx", "AWS_DEFAULT_REGION" = "xxxxx")
athenaconnect <- dbConnect( AWR.Athena::Athena(), region = Sys.getenv( "AWS_DEFAULT_REGION" ), S3OutputLocation = 's3://aws-athena-query-results-xxxxxx-eu-central-1/', Schema = 'default', user = Sys.getenv( "AWS_ACCESS_KEY_ID" ), password = Sys.getenv( "AWS_SECRET_ACCESS_KEY" ) )
dbGetQuery( athenaconnect, "MSCK REPAIR TABLE .") This currently doesnt work with an error: ([Simba]JDBC A ResultSet was expected but not generated from query "MSCK REPAIR TABLE . ". Query not executed. ) Maybe there is a different 'dbGetQuery' command, but have hunted around and can only see dbGetQuery and dbListTables. This functionality if not already available would be great thanks gaborcsardi commented 4 years ago Hi, this is a read only mirror of CRAN, please see the package authors in the DESCRIPTION file. Thanks! StuShepherdUK commented 4 years ago Ah thank you.. have looked and see your name mentioned along side another... but no main github repository to raise issues\questions... i dont spose you would have the link to the original site? many thanks. gaborcsardi commented 4 years ago See https://github.com/cran/AWR.Athena/blob/0499738ed1933efb87ceb8102e21beefed89b777/DESCRIPTION#L6
This currently doesnt work with an error:
([Simba]JDBC A ResultSet was expected but not generated from query "MSCK REPAIR TABLE . ". Query not executed. ) Maybe there is a different 'dbGetQuery' command, but have hunted around and can only see dbGetQuery and dbListTables. This functionality if not already available would be great thanks gaborcsardi commented 4 years ago Hi, this is a read only mirror of CRAN, please see the package authors in the DESCRIPTION file. Thanks! StuShepherdUK commented 4 years ago Ah thank you.. have looked and see your name mentioned along side another... but no main github repository to raise issues\questions... i dont spose you would have the link to the original site? many thanks. gaborcsardi commented 4 years ago See https://github.com/cran/AWR.Athena/blob/0499738ed1933efb87ceb8102e21beefed89b777/DESCRIPTION#L6
Maybe there is a different 'dbGetQuery' command, but have hunted around and can only see dbGetQuery and dbListTables.
This functionality if not already available would be great thanks
Hi, this is a read only mirror of CRAN, please see the package authors in the DESCRIPTION file. Thanks!
DESCRIPTION
Ah thank you.. have looked and see your name mentioned along side another... but no main github repository to raise issues\questions... i dont spose you would have the link to the original site? many thanks.
See https://github.com/cran/AWR.Athena/blob/0499738ed1933efb87ceb8102e21beefed89b777/DESCRIPTION#L6
From within R, am looking to perform the MSCK repair table to ensure the partitions are correct before downloading data.
Current script example:
library(AWR.Athena) Sys.setenv("AWS_ACCESS_KEY_ID" = "xxxxxxx", "AWS_SECRET_ACCESS_KEY" = "xxxxxx", "AWS_DEFAULT_REGION" = "xxxxx")
athenaconnect <- dbConnect( AWR.Athena::Athena(), region = Sys.getenv( "AWS_DEFAULT_REGION" ), S3OutputLocation = 's3://aws-athena-query-results-xxxxxx-eu-central-1/', Schema = 'default', user = Sys.getenv( "AWS_ACCESS_KEY_ID" ), password = Sys.getenv( "AWS_SECRET_ACCESS_KEY" ) )
dbGetQuery( athenaconnect, "MSCK REPAIR TABLE.")
This currently doesnt work with an error:
([Simba]JDBC A ResultSet was expected but not generated from query "MSCK REPAIR TABLE. ". Query not executed. )
gaborcsardi
commented
4 years ago
StuShepherdUK
commented
4 years ago
gaborcsardi
commented
4 years ago
- © Githubissues.
- Githubissues is a development platform for aggregating issues.
Maybe there is a different 'dbGetQuery' command, but have hunted around and can only see dbGetQuery and dbListTables.
This functionality if not already available would be great thanks
Hi, this is a read only mirror of CRAN, please see the package authors in the
DESCRIPTION
file. Thanks!Ah thank you.. have looked and see your name mentioned along side another... but no main github repository to raise issues\questions... i dont spose you would have the link to the original site? many thanks.
See https://github.com/cran/AWR.Athena/blob/0499738ed1933efb87ceb8102e21beefed89b777/DESCRIPTION#L6