I am running a very simple Insert into a table. My insert query is as follows:
This works as expected. However when I run the subsequent:
I get the following error message. I am not sure why this is the case.
ERROR: ArgumentError: Unable to parse date time. Expected directive Delim(\z) at char 24
Stacktrace:
[1] macro expansion at ./dates/parse.jl:106 [inlined]
[2] tryparsenext_core(::String, ::Int64, ::Int64, ::DateFormat{Symbol("y-m-d HH:MM:SS.sssz"),Tuple{Base.Dates.DatePart{'y'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'m'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'d'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'H'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'M'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'S'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'s'},Base.Dates.Delim{Char,1}}}, ::Bool) at ./dates/parse.jl:39
[3] macro expansion at ./dates/parse.jl:153 [inlined]
[4] tryparsenext_internal(::Type{TimeZones.ZonedDateTime}, ::String, ::Int64, ::Int64, ::DateFormat{Symbol("y-m-d HH:MM:SS.sssz"),Tuple{Base.Dates.DatePart{'y'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'m'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'d'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'H'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'M'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'S'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'s'},Base.Dates.Delim{Char,1}}}, ::Bool) at ./dates/parse.jl:129
[5] parse(::Type{TimeZones.ZonedDateTime}, ::String, ::DateFormat{Symbol("y-m-d HH:MM:SS.sssz"),Tuple{Base.Dates.DatePart{'y'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'m'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'d'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'H'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'M'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'S'},Base.Dates.Delim{Char,1},Base.Dates.DatePart{'s'},Base.Dates.Delim{Char,1}}}) at ./dates/parse.jl:270
[6] parse(::Type{TimeZones.ZonedDateTime}, ::LibPQ.PQValue{0x000004a0}) at /var/task/julia/v0.6/LibPQ/src/parsing.jl:256
[7] (::LibPQ.#parse_type#40{DataType})(::LibPQ.PQValue{0x000004a0}) at /var/task/julia/v0.6/LibPQ/src/parsing.jl:355
[8] streamfrom(::LibPQ.Result, ::Type{DataStreams.Data.Field}, ::Type{Union{Missings.Missing, TimeZones.ZonedDateTime}}, ::Int64, ::Int64) at /var/task/julia/v0.6/LibPQ/src/datastreams.jl:60
[9] macro expansion at /var/task/julia/v0.6/DataStreams/src/query.jl:484 [inlined]
[10] stream!(::LibPQ.Result, ::DataStreams.Data.Query{0x01,Tuple{DataStreams.Data.QueryColumn{0x01,Union{Int32, Missings.Missing},1,1,:id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},2,2,:global_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},3,3,:damage_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Int32, Missings.Missing},4,4,:rule_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},5,5,:attrs,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, TimeZones.ZonedDateTime},6,6,:insert_timestamp,nothing,()}},(),nothing,nothing}, ::Type{DataStreams.Data.Field}, ::NamedTuples._NT_id_global__id_damage__id_rule__id_attrs_insert__timestamp{Array{Union{Int32, Missings.Missing},1},Array{Union{Missings.Missing, String},1},Array{Union{Missings.Missing, String},1},Array{Union{Int32, Missings.Missing},1},Array{Union{Missings.Missing, String},1},Array{Union{Missings.Missing, TimeZones.ZonedDateTime},1}}, ::DataStreams.Data.Schema{true,Tuple{Union{Int32, Missings.Missing},Union{Missings.Missing, String},Union{Missings.Missing, String},Union{Int32, Missings.Missing},Union{Missings.Missing, String},Union{Missings.Missing, TimeZones.ZonedDateTime}}}, ::Int64) at /var/task/julia/v0.6/DataStreams/src/query.jl:628
[11] #stream!#122(::Bool, ::Array{Any,1}, ::Function, ::LibPQ.Result, ::DataStreams.Data.Query{0x01,Tuple{DataStreams.Data.QueryColumn{0x01,Union{Int32, Missings.Missing},1,1,:id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},2,2,:global_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},3,3,:damage_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Int32, Missings.Missing},4,4,:rule_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},5,5,:attrs,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, TimeZones.ZonedDateTime},6,6,:insert_timestamp,nothing,()}},(),nothing,nothing}, ::Type{NamedTuples.NamedTuple}) at /var/task/julia/v0.6/DataStreams/src/query.jl:598
[12] (::DataStreams.Data.#kw##stream!)(::Array{Any,1}, ::DataStreams.Data.#stream!, ::LibPQ.Result, ::DataStreams.Data.Query{0x01,Tuple{DataStreams.Data.QueryColumn{0x01,Union{Int32, Missings.Missing},1,1,:id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},2,2,:global_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},3,3,:damage_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Int32, Missings.Missing},4,4,:rule_id,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, String},5,5,:attrs,nothing,()},DataStreams.Data.QueryColumn{0x01,Union{Missings.Missing, TimeZones.ZonedDateTime},6,6,:insert_timestamp,nothing,()}},(),nothing,nothing}, ::Type{NamedTuples.NamedTuple}) at ./<missing>:0
[13] #stream!#120(::Bool, ::Dict{Int64,Function}, ::Function, ::Array{Any,1}, ::Array{Any,1}, ::Void, ::Void, ::Array{Any,1}, ::DataStreams.Data.#stream!, ::LibPQ.Result, ::Type{NamedTuples.NamedTuple}) at /var/task/julia/v0.6/DataStreams/src/query.jl:548
[14] stream!(::LibPQ.Result, ::Type{NamedTuples.NamedTuple}) at /var/task/julia/v0.6/DataStreams/src/query.jl:526
[15] #fetch!#43(::Array{Any,1}, ::Function, ::Type{T} where T, ::LibPQ.Result) at /var/task/julia/v0.6/LibPQ/src/datastreams.jl:138
[16] runQuery(::LibPQ.Connection, ::String, ::Vararg{Any,N} where N) at /tmp/tmpZS6Hr3/julia/ssql/PostgreSql.jl:16
[17] (::DamageDb.#make_damage#4{Dict{Symbol,Any}})(::LibPQ.Connection) at /tmp/tmpZS6Hr3/julia/ssql/DamageDb.jl:25
[18] transact(::LibPQ.Connection, ::DamageDb.#make_damage#4{Dict{Symbol,Any}}) at /tmp/tmpZS6Hr3/julia/ssql/PostgreSql.jl:23
[19] #new_damage#1(::Array{Any,1}, ::Function) at /tmp/tmpZS6Hr3/julia/ssql/DamageDb.jl:63
[20] (::DamageDb.#kw##new_damage)(::Array{Any,1}, ::DamageDb.#new_damage) at ./<missing>:0
[21] evalRequest(::Array{Dict{String,Any},1}, ::Dict{String,Any}) at /tmp/tmpZS6Hr3/julia/ssql/Engine.jl:61
[22] lambda_function_with_event(::Dict{String,Any}) at /tmp/tmpZS6Hr3/module_ssql_request.jl:12
[23] invoke_lambda(::Module, ::Dict{String,Any}, ::IOStream) at /var/task/julia/v0.6/AWSLambdaWrapper.jl:35
[24] open(::AWSLambdaWrapper.##1#2{Module}, ::String, ::String) at ./iostream.jl:152
[25] main(::Module) at /var/task/julia/v0.6/AWSLambdaWrapper.jl:50
[26] process_options(::Base.JLOptions) at ./client.jl:286
[27] _start() at ./client.jl:371
The table is fairly simple as well. Its schema is as follows: