no particular reason. just wanted to know if there was another way as well.
thanks
On Saturday, 27 February 2016, 22:12, Yin Yang wrote:
Is there particular reason you cannot use temporary table ?
Thanks
On Sat, Feb 27, 2016 at 10:59 AM, Ashok Kumar wrote:
Thank you sir.
Can one do thi
Is there particular reason you cannot use temporary table ?
Thanks
On Sat, Feb 27, 2016 at 10:59 AM, Ashok Kumar wrote:
> Thank you sir.
>
> Can one do this sorting without using temporary table if possible?
>
> Best
>
>
> On Saturday, 27 February 2016, 18:50, Yin Yang wrote:
>
>
> scala> Seq
Thank you sir.
Can one do this sorting without using temporary table if possible?
Best
On Saturday, 27 February 2016, 18:50, Yin Yang wrote:
scala> Seq((1, "b", "test"), (2, "a", "foo")).toDF("id", "a",
"b").registerTempTable("test")
scala> val df = sql("SELECT struct(id, b, a) from te
scala> Seq((1, "b", "test"), (2, "a", "foo")).toDF("id", "a",
"b").registerTempTable("test")
scala> val df = sql("SELECT struct(id, b, a) from test order by b")
df: org.apache.spark.sql.DataFrame = [struct(id, b, a): struct]
scala> df.show
++
|struct(id, b, a)|
++
Is this what you look for ?
scala> Seq((2, "a", "test"), (2, "b", "foo")).toDF("id", "a",
"b").registerTempTable("test")
scala> val df = sql("SELECT struct(id, b, a) from test")
df: org.apache.spark.sql.DataFrame = [struct(id, b, a): struct]
scala> df.show
++
|struct(id, b, a)|
+
Hello,
I like to be able to solve this using arrays.
I have two dimensional array of (String,Int) with 5 entries say arr("A",20),
arr("B",13), arr("C", 18), arr("D",10), arr("E",19)
I like to write a small code to order these in the order of highest Int column
so I will have arr("A",20), arr("E
