Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [geomesa-users] Querying a interger column


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.



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.

***************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
To unsubscribe from this list, visit

Back to the top