Re: [geomesa-users] Querying a interger column

[Emilio Lahr-Vivaz <elahrvivaz@xxxxxxxx>]

    Hello,
    
    Did you figure anything out? I'm not really sure, but maybe the
    dates are not being parsed correctly, in our examples, we use a
    format like "'2016-01-02T01:00:00Z'". Executing "explain select ..."
    might give you more information about how the query is being parsed.
    
    Thanks,
    
    Emilio

On 11/24/20 11:21 PM, Danilo Degracia wrote:

Hi all,

Just wondering if I can get some help to properly query in python using geomesa interger 9780873, below code give blank results. T

df=spark.sql("""select * from df where

           imo = 9780873 and

           dtg > cast('2019-01-01 00:00' as timestamp) and  

           dtg < cast('2010-12-31 00:00' as timestamp)""")

Thank you in advance.

Regards,
Danilo

***************Este mensaje (y sus adjuntos), en adelante "mensaje", ha sido enviado exclusivamente a su(s) destinatario(s) y es confidencial. Si usted recibe este mensaje por error, por favor bórrelo y comunique inmediatamente al remitente. Toda utilización o publicación, total o parcial, queda prohibida salvo autorización expresa. La UTP no podrá ser considerada responsable si el mensaje ha sido modificado y/o utilizado sin autorización. This message (and any attachments), are confidential intended solely for the people whose addresses appear. If you have received this message by error, please delete it and immediately notify the sender. Any use, dissemination or disclosure, either whole or partial, without formal approval is prohibited. The UTP will not therefore be liable for the message if modified and/or used without approval.**************

_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxx
To unsubscribe from this list, visit https://dev.eclipse.org/mailman/listinfo/geomesa-users