[I] [Go] How to use prepared statements with timestamps [arrow-go]

[via GitHub]

si-fernandes opened a new issue, #39:
URL: https://github.com/apache/arrow-go/issues/39

   ### Describe the usage question you have. Please include as many useful 
details as  possible.
   
   
   Hello,
   
   I'm trying to implement a prepared statement that has a timestamp parameter.
   I have prepared statements working with strings, but with timestamps I'm 
getting a schema mismatch error.
   I'm using v14. 
   
   The query for the prepared statement is `SELECT * FROM x where name = $1 AND 
$2 <= timestamp`.
   I have no problems with the first parameter.
   I'm building the second parameter using the type 
`arrow.FixedWidthTypes.Timestamp_ns`.
   I've tried passing a `time.Time` as the value and it failed. Then I tried an 
`arrow.Timestamp` but that also failed with the same error.
   
   The error I'm getting is:
   ```
   Parameter schema does not equal Placeholder schema. (...) 
   Received: (...) Field {name: \"$2\", data_type: Timestamp(Nanosecond, 
Some(\"UTC\")), nullable: true, dict_id: 0, dict_is_ordered: false, metadata: 
{} }
   Expected: (...)Field { name: \"$2\", data_type: Timestamp(Nanosecond, None), 
nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }
   ```
   
   I would like to know what's the best way to overcome this timezone 
difference in the schemas.
   
   Thank you
   
   EDIT:
   I have also tried casting the `timestamp` to `timestamptz` in the query, but 
that leads to the mismatch 
   ```
   Received: Timestamp(Nanosecond, Some(\"UTC\"))
   Expected: Timestamp(Nanosecond, Some(\"+00:00\"))
   ```
   
   
   
   ### Component(s)
   
   Go


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org