KNOWLEDGE BASE

Syntax error "Column 'partitioned_tablename.# partition information' cannot be resolved" appears when trying to connect to a partitioned table in Amazon Athena


Published: 31 Jul 2018
Last Modified Date: 22 Aug 2018

Issue

An error occurs when a partitioned table in Amazon Athena is used in Tableau Desktop: 
 
An error occurred when executing the SQL command:
SELECT   "partitioned_tablename"."# Partition Information" AS "x_partition_inform", 
 "partitioned_tablename"."# col_name" AS "x_col_name", 
1 AS "number_of_recor...
...
[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. SYNTAX_ERROR: line 1:10: Column 'partitioned_tablename.# partition information' cannot be resolved [SQL State=HY000, DB Errorcode=100071]

1 statement failed.


 

Environment

  • Tableau Desktop 10.4.1, 2018.1.3
  • Amazon Athena

Resolution

  1. Remove your current Athena driver .jar file from C:\Program Files\Tableau\Drivers.
  2. Download and install the Amazon Athena 2.0.3 or newer driver. For more information, see Amazon Athena under Driver Download

Cause

This behavior is related to a known issue with the Athena JDBC 2.0.2 driver
Did this article resolve the issue?