Re: Spark SQL: How to get the hierarchical element with SQL?

2014-12-08 Thread Alessandro Panebianco
I went through complex hierarchal JSON structures and Spark seems to fail in querying them no matter what syntax is used. Hope this helps, Regards, Alessandro > On Dec 8, 2014, at 6:05 AM, Raghavendra Pandey > wrote: > > Yeah, the dot notation works. It works even for arrays. But I am not

Re: SparkSQL Timestamp query failure

2014-11-23 Thread Alessandro Panebianco
Hey Daoyuan, following your suggestion I obtain the same result as when I do: where l.timestamp = '2012-10-08 16:10:36.0’ what happens using either your suggestion or simply using single quotes as I just typed in the example before is that the query does not fail but it doesn’t return anythin