using JuliaDB
using IndexedTables
using CSV
dt = table()
dt = loadtable(
"data";
filenamecol = :Ticker,
header_exists = false,
skiplines_begin = 1,
colnames = ["pid", "v1", "v2", "v3", "extend", "t", "mid"],
) #加载data目录下所有文件，合并到同一table中
数据集
玩家PID,事件ID(一级),事件参数(二级),事件参数值(三级),扩展字段1,事件时间,原始设备ID
11066774,Level1Move_A,st008,,"1159,4,1,3,3,3,0,0,0",2020-07-11 15:48:37,546_555555555575o5296q75p4qpn7
11066861,TutorialEnter_A,304,,,2020-07-11 15:44:09,352_584555555975155r1q5s1n4s24
11067103,LevelMd5_A,st008,,"f00ea90b24cd2bedfb743c796844f99f,1594473957,OM3_0.2.2.11",2020-07-11 20:25:57,557sp3187sp4o7439
11066717,TutorialFinish_A,301,,2.7728567123413,2020-07-11 16:09:16,69q08q40nr2111q30
11066694,LevelStart_A,st009,0.5701452,"1331,5,1,3,3,3,0,0,0",2020-07-11 10:20:31,9pp829s2s80ron955
11067146,GetGold_A,GainCoinPassLevelAdd,150,,2020-07-11 21:34:16,88nn_55555555557566223r92o8rnr
11067071,TutorialFinish_A,101,,5.5751647949219,2020-07-11 20:35:19,235qrs7395555q_75555555032qrp9
11066855,TutorialFinish_A,102,,2.5934410095215,2020-07-11 14:33:00,350_5n65555557759557so7nq702p6
11063847,LoginSuccess_A,,,,2020-07-11 22:39:08,3849p8r1nosoq7701
11066821,LevelStart_A,st016,0.3335689,"2539,3,2,3,2,3,0,0,0",2020-07-11 21:43:04,8pp1_55555555557578q606o2rpq75
11066894,TutorialFinish_A,402,,3.784912109375,2020-07-11 15:34:27,353_511555555775r557860o8oq96o
11064949,LevelFailed_A,st011,,"739,4,23,3,3,3,0,0,0,0,0,0,0,0,103.1562,0,0.8734177",2020-07-11 07:29:08,8s22_55555555557538q2q8o418p12
11067031,LevelStart_A,st008,0.9484419,"1179,5,1,3,3,3,0,0,0",2020-07-11 19:02:34,8o257nr55979sqr86
11066741,TutorialEnter_A,203,,,2020-07-11 12:30:08,354_5n7555555675s55927psnp5026
,Level1Move_A,st001,,"0,4,1,3,3,3,0,0,0",2020-07-10 23:30:15,35r_5o2555555175555p558n3p701n
11066252,LevelBtnClick_A,st027,,"374,4,0,0,2,2,0,0,0",2020-07-11 12:29:41,220q5ons55555p_7555555544p22sq
11066863,LevelSuccess_A,st002,,"314,4,1,3,3,3,0,0,0,0,0,0,0,0,191.4452,0,12,13",2020-07-11 15:48:24,5r4q03s6s4q67nn61
11066822,LevelSuccess_A,st002,,"317,4,1,3,3,3,0,0,0,0,0,0,0,0,39.87088,0,13,12",2020-07-11 13:46:03,8409_55555555557509811121qnn11
11066621,SDKLoginSuccess_A,visitor,,,2020-07-11 07:22:23,6p8n34_55555555557580r39s7q14p
11066555,GetGold_A,GainCoinPassLevelAdd,150,,2020-07-11 06:53:32,596_55555555557548s0rrsno2o595
,ossdk_login,login_request,guest,,2020-07-11 01:38:49,455o_554s5555p075o75560n57898n
11067114,LevelMd5_A,st004,,"40629fc4b30b26a8c25218975ddaff12,1594475348,OM3_0.2.2.11",2020-07-11 20:49:08,7nqp9rr08_555555555575ss54qp9
报错信息：
UndefRefError: access to undefined reference
getindex at C:\Users\ping.zhou.julia\packages\WeakRefStrings\lqf5B\src\WeakRefStrings.jl:260 [inlined]
get_ith at C:\Users\ping.zhou.julia\packages\StructArrays\OtfvU\src\structarray.jl:137 [inlined]
get_ith at C:\Users\ping.zhou.julia\packages\StructArrays\OtfvU\src\structarray.jl:138 [inlined] (repeats 4 times)
get_ith at C:\Users\ping.zhou.julia\packages\StructArrays\OtfvU\src\structarray.jl:135 [inlined]
getindex at C:\Users\ping.zhou.julia\packages\StructArrays\OtfvU\src\structarray.jl:151 [inlined]
iterate at .\abstractarray.jl:986 [inlined]
iterate at .\abstractarray.jl:984 [inlined]
iterate at C:\Users\ping.zhou.julia\packages\IndexedTables\vl8XI\src\indexedtable.jl:212 [inlined]
isempty at .\essentials.jl:737 [inlined]
domain(::IndexedTable{StructArrays.StructArray{NamedTuple{(:Ticker, :pid, :v1, :v2, :v3, :extend, :t, :mid, Symbol(“4”)),Tuple{String,Union{Missing, Int64},String,String,String,String,Dates.DateTime,String,String}},1,NamedTuple{(:Ticker, :pid, :v1, :v2, :v3, :extend, :t, :mid, Symbol(“4”)),Tuple{Array{String,1},Array{Union{Missing, Int64},1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1},Array{Dates.DateTime,1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1}}},Int64}}) at C:\Users\ping.zhou.julia\packages\JuliaDB\7cG1k\src\table.jl:36
tochunk(::IndexedTable{StructArrays.StructArray{NamedTuple{(:Ticker, :pid, :v1, :v2, :v3, :extend, :t, :mid, Symbol(“4”)),Tuple{String,Union{Missing, Int64},String,String,String,String,Dates.DateTime,String,String}},1,NamedTuple{(:Ticker, :pid, :v1, :v2, :v3, :extend, :t, :mid, Symbol(“4”)),Tuple{Array{String,1},Array{Union{Missing, Int64},1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1},Array{Dates.DateTime,1},WeakRefStrings.StringArray{String,1},WeakRefStrings.StringArray{String,1}}},Int64}}; persist::Bool, cache::Bool) at C:\Users\ping.zhou.julia\packages\Dagger\sdZXi\src\chunks.jl:107
do_task(::Dagger.Context, ::Dagger.OSProc, ::Int64, ::Function, ::Tuple{Array{String,1}}, ::Bool, ::Bool, ::Bool) at C:\Users\ping.zhou.julia\packages\Dagger\sdZXi\src\scheduler.jl:260
#137 at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.5\Distributed\src\remotecall.jl:354 [inlined]
run_work_thunk(::Distributed.var"#137#138"{typeof(Dagger.Sch.do_task),Tuple{Dagger.Context,Dagger.OSProc,Int64,JuliaDB.var"#190#193"{Array{Any,1},Base.Iterators.Pairs{Symbol,Any,NTuple{4,Symbol},NamedTuple{(:filenamecol, :header_exists, :skiplines_begin, :colnames),Tuple{Symbol,Bool,Int64,Array{String,1}}}},UnionAll},Tuple{Array{String,1}},Bool,Bool,Bool},Base.Iterators.Pairs{Union{},Union{},Tuple{},NamedTuple{(),Tuple{}}}}, ::Bool) at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.5\Distributed\src\process_messages.jl:79
remotecall_fetch(::Function, ::Distributed.LocalProcess, ::Dagger.Context, ::Vararg{Any,N} where N; kwargs::Base.Iterators.Pairs{Union{},Union{},Tuple{},NamedTuple{(),Tuple{}}}) at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.5\Distributed\src\remotecall.jl:379
remotecall_fetch(::Function, ::Distributed.LocalProcess, ::Dagger.Context, ::Vararg{Any,N} where N) at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.5\Distributed\src\remotecall.jl:379
remotecall_fetch(::Function, ::Int64, ::Dagger.Context, ::Vararg{Any,N} where N; kwargs::Base.Iterators.Pairs{Union{},Union{},Tuple{},NamedTuple{(),Tuple{}}}) at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.5\Distributed\src\remotecall.jl:421
remotecall_fetch at D:\buildbot\worker\package_win64\build\usr\share\julia\stdlib\v1.5\Distributed\src\remotecall.jl:421 [inlined]
macro expansion at C:\Users\ping.zhou.julia\packages\Dagger\sdZXi\src\scheduler.jl:272 [inlined]
(::Dagger.Sch.var"#13#14"{Dagger.Context,Dagger.OSProc,Int64,JuliaDB.var"#190#193"{Array{Any,1},Base.Iterators.Pairs{Symbol,Any,NTuple{4,Symbol},NamedTuple{(:filenamecol, :header_exists, :skiplines_begin, :colnames),Tuple{Symbol,Bool,Int64,Array{String,1}}}},UnionAll},Tuple{Array{String,1}},Channel{Any},Bool,Bool,Bool})() at .\task.jl:356
compute_dag(::Dagger.Context, ::Dagger.Thunk) at scheduler.jl:62
compute(::Dagger.Context, ::Dagger.Thunk) at compute.jl:25
fromchunks(::Array{Dagger.Thunk,1}; output::Nothing, fnoffset::Int64, kwargs::Base.Iterators.Pairs{Union{},Union{},Tuple{},NamedTuple{(),Tuple{}}}) at table.jl:148
(::JuliaDB.var"#fromchunks##kw")(::NamedTuple{(:output, :fnoffset),Tuple{Nothing,Int64}}, ::typeof(JuliaDB.fromchunks), ::Array{Dagger.Thunk,1}) at table.jl:129
_loadtable(::Type{T} where T, ::String; chunks::Nothing, output::Nothing, append::Bool, indexcols::Array{Any,1}, distributed::Bool, usecache::Bool, opts::Base.Iterators.Pairs{Symbol,Any,NTuple{4,Symbol},NamedTuple{(:filenam…
如果把数据集中的最后一行删除，则能正常运行。