[ckan-discuss] Random column sorting in grid preview for csv resource in datahub.io

Tue Jul 24 23:49:22 BST 2012

2012/7/24 Rufus Pollock <rufus.pollock at okfn.org>:
> On 20 July 2012 17:51, José Félix Ontañon <fontanon at emergya.com> wrote:
>> I guess the data type for storing the key/values is a python
>> dictionary, and it doesn't store any sort order. Am i wrong?
>
> Strictly it's a JSON dictionary in ElasticSearch but the same answer.
>
>> If this is to be fixed I could give a hand, maybe.
>> Is there any ticket for tracking advances in this issue?
>
> There is no simple way to fix this without some actual work to store
> this when we create the DataStore table in ElasticSearch. We're
> working on a new Postgres based DataStore which may assist with
> solving this issue.
>
> Rufus

Ok, I understand. Thanks Rufus.

>> Cheers,
>>
>> 2012/7/19 Rufus Pollock <rufus.pollock at okfn.org>:
>>> OK, simple answer: the datastore as pure key/value does not support
>>> storing the original column sort order - you just get the order the
>>> keys come back in.
>>>
>>> This is something we've been thinking about (e.g. storing column sort
>>> order in the _meta of the mapping).
>>>
>>> I note this does not happen with the dataproxy because that returns
>>> the column order (and recline supports preserving column order).
>>>
>>> Rufus
>>>
>>> On 19 July 2012 20:48, José Félix Ontañon <fontanon at emergya.com> wrote:
>>>> 2012/7/19 Rufus Pollock <rufus.pollock at okfn.org>:
>>>>> Can you point to the dataset?
>>>>>
>>>>> Rufus
>>>>
>>>> Oh! Sorry
>>>>
>>>> This is the dataset URL: http://datahub.io/dataset/seville-budget
>>>> And this is the resource:
>>>> http://datahub.io/dataset/seville-budget/resource/accfda1e-e3ed-40fe-a683-69645ab51f5b
>>>>
>>>> Regards,
>>>>
>>>>> On 19 July 2012 19:56, José Félix Ontañon <fontanon at emergya.com> wrote:
>>>>>> Hi, I'm not sure this is the correct mailing list for my question. If
>>>>>> i'm wrong, please show me the right one,
>>>>>>
>>>>>> I've uploaded recently a csv file as resource for a dataset i'm
>>>>>> working inside datahub.io
>>>>>> The grid preview isn't displaying columns sorted as in the csv, but in
>>>>>> a random order, why?
>>>>>>
>>>>>> Is there anything I can do?
>>>>>> Regards,
>>>>>>
>>>>>> --
>>>>>> J. Félix Ontañón Carmona
>>>>>> Emergya Consultoría
>>>>>>
>>>>>> _______________________________________________
>>>>>> ckan-discuss mailing list
>>>>>> ckan-discuss at lists.okfn.org
>>>>>> http://lists.okfn.org/mailman/listinfo/ckan-discuss
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Co-Founder, Open Knowledge Foundation
>>>>> Promoting Open Knowledge in a Digital Age
>>>>> http://www.okfn.org/ - http://blog.okfn.org/
>>>>
>>>>
>>>>
>>>> --
>>>> J. Félix Ontañón Carmona
>>>> Emergya Consultoría
>>>
>>>
>>>
>>> --
>>> Co-Founder, Open Knowledge Foundation
>>> Promoting Open Knowledge in a Digital Age
>>> http://www.okfn.org/ - http://blog.okfn.org/
>>
>>
>>
>> --
>> J. Félix Ontañón Carmona
>> Emergya Consultoría
>
>
>
> --
> Co-Founder, Open Knowledge Foundation
> Promoting Open Knowledge in a Digital Age
> http://www.okfn.org/ - http://blog.okfn.org/

-- 
J. Félix Ontañón Carmona
Emergya Consultoría