Re: [geomesa-users] Querying a interger column

[Danilo Degracia <danilo.degracia@xxxxxxxxx>]

Thank you very much for replying.

Dates are working fine, but the imo which is an integer is not being recognized, so I am not sure if I should use quotes for it or something else.

Thank you

Danilo

---

From: geomesa-users-bounces@xxxxxxxxxxx <geomesa-users-bounces@xxxxxxxxxxx> on behalf of Emilio Lahr-Vivaz <elahrvivaz@xxxxxxxx>
Sent: Monday, November 30, 2020 7:05 AM
To: geomesa-users@xxxxxxxxxxx <geomesa-users@xxxxxxxxxxx>
Subject: Re: [geomesa-users] Querying a interger column

 

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

***************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.**************

***************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.**************