# Unsure about Query error

**URL:** <https://discourse.julialang.org/t/unsure-about-query-error/4432>\
**Category:** Data\
**Tags:** question\
**Created:** [June 23, 2017, 8:51pm UTC](https://discourse.julialang.org/t/unsure-about-query-error/4432 "2017-06-23T20:51:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zorp](https://avatars.discourse-cdn.com/v4/letter/z/c2a13f/32.png) [@zorp](https://discourse.julialang.org/u/zorp)\
**Post date:** [June 23, 2017, 8:51pm UTC](https://discourse.julialang.org/t/unsure-about-query-error/4432/1 "2017-06-23T20:51:26Z")

</div>

I’ve started learning Julia today and have been trying to use it to work on some botany questions that I’ve been thinking about for a time now. I’ve stored two CSVs relevant to the problems in variables (which are DataFrames) called _plots_ and _species_. I tried executing the following:

```julia
plots_w_elev = @from s in species begin
	@where s.currentTaxonName == "Pinus echinata"
	@join p in plots on s.OBSERVATION_ID equals p.OBSERVATION_ID
	@select {id=s.OBSERVATION_ID, elev=p.Elevation}
	@collect DataFrame
end

```

but was greeted by a rather unfriendly looking error whose cause I need help understanding:

```julia
ERROR: MethodError: no method matching NamedTuples._NT_OBSERVATION __ID_Author__ Observation __Code_pcOrd__ plot __code_Observation__ Start __Date_Observation__ End __Date_province_state_countyName_quadrangle_Confidentiality__ Status_Real __Latitude_Real__ Longitude_Location __Accuracy_Public__ Latitude_Public __Longitude_realUTME_realUTMN_realUTMZone_Taxon__ Observation __Area_Stem__ Observation __Area_Effort__ Level_Floristic __Quality_Bryophyte__ Quality_Lichen
...
Closest candidates are:
  NamedTuples._NT_OBSERVATION __ID_Author__ Observation __Code_pcOrd__ plot __code_Observation__ Start __Date_Observation__ End __Date_province_state_countyName_quadrangle_Confidentiality__ Status_Real __Latitude_Real__ Longitude_Location __Accuracy_Public__ Latitude_Public __Longitude_realUTME_realUTMN_realUTMZone_Taxon__ Observation __Area_Stem__ Observation __Area_Effort__ Level_Floristic __Quality_Bryophyte__ Quality_Lichen
...
{Int64}}{T}(::Any) at sysimg.jl:53
in #52 at base/task.jl:60
in macro expansion at Atom/src/eval.jl:49
in withpath at Atom/src/eval.jl:38
in withpath at CodeTools/src/utils.jl:30
in #53 at Atom/src/eval.jl:50
in include_string at CodeTools/src/eval.jl:34
in include_string at CodeTools/src/eval.jl:30
in collect at Query/src/sinks/sink_type.jl:2
in Type at IterableTables/src/integrations/dataframes.jl:125
in _DataFrame at IterableTables/src/integrations/dataframes.jl:116
in _filldf at IterableTables/src/integrations/dataframes.jl:79
in macro expansion at IterableTables/src/integrations/dataframes.jl:91
in start at Query/src/enumerable/enumerable_convert2nullable.jl:43
in start at Query/src/enumerable/enumerable_join.jl:40
in next at Query/src/enumerable/enumerable_convert2datavalue.jl:47
in macro expansion at Query/src/enumerable/enumerable_convert2datavalue.jl:58
in next at Query/src/sources/source_iterable.jl:29
in next at IterableTables/src/integrations/dataframes.jl:55
in macro expansion at IterableTables/src/integrations/dataframes.jl:67

```

Any help would be appreciated. Thanks!

---

<div class="post-metadata">

**Author:** ![davidanthoff](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/davidanthoff/32/223493_2.png) [@davidanthoff](https://discourse.julialang.org/u/davidanthoff)\
**Post date:** [June 23, 2017, 9:43pm UTC](https://discourse.julialang.org/t/unsure-about-query-error/4432/2 "2017-06-23T21:43:08Z")

</div>

Can you try this on julia 0.6, making sure you have the latest packages (i.e. do a `Pkg.update()`)? I just tried the same query on some made-up data and it seemed to work for me on the latest released version of Query.jl.

---

<div class="post-metadata">

**Author:** ![zorp](https://avatars.discourse-cdn.com/v4/letter/z/c2a13f/32.png) [@zorp](https://discourse.julialang.org/u/zorp)\
**Post date:** [June 23, 2017, 10:00pm UTC](https://discourse.julialang.org/t/unsure-about-query-error/4432/3 "2017-06-23T22:00:06Z")

</div>

Yeah. Bumping Julia from 0.53 to 0.6 fixed it. Thanks for suggesting that!