为什么我的 Amazon Athena 查询出现错误，提示“HIVE_BAD_DATA: Error parsing field value for field X: For input string: "12312845691"”？

为什么我在查询 Amazon Athena 表时收到零个记录？

如何排除 Amazon Athena 中的“函数未注册”语法错误？

为什么会收到下列错误“HIVE_BAD_DATA: Error parsing field value '' for field X: For input string: """ when I query JSON data in Amazon Athena?

@Smotrov were you able to find a solution?

According [to documentation](https://docs.aws.amazon.com/athena/latest/ug/data-types.html) Athena support binary fields. 

> binary – Used for data in Parquet.

Is there any way to prepare insert statement to insert data in binary field using aws-sdk for NodeJS? 
For me is is not clear how to put binary data into [queryString](https://docs.aws.amazon.com/AWSJavaScriptSDK/v3/latest/clients/client-athena/interfaces/startqueryexecutioncommandinput.html#querystring) of `INSERT INTO` statement? 

Thank you in advance!

How to insert data into binary field in Athena

分析

PowerBI 访问 S3/Athena

Athena - Athena查询PostgreSQL数据库数据报错 - GENERIC_USER_ERROR

Athena Error- HIVE_BAD_DATA: Not valid Parquet file: s3://deng-utube-raw-us-east-1-dev/youtube/raw_stats_reference_data/FR_category_id.json expected magic number: PAR1 got: ] }

HIVE_BAD_DATA：解析第3个字段值“2021-10-31 22:00:00.0”时出错：输入字符串：“2021-10-31 22:00:00.0”。

How to insert data into binary field in Athena

相关内容