# execute this in pyspark

from time import time


a = time()
l = spark.read.text('wikirank-fr.tsv')
c = l.sort('value').show()
print ("Count :", c)
print ("Time :", time()-a)

a = time()
l = spark.read.text('wikirank-fr.tsv')
c = l.sort('value').count()
print ("Count :", c)
print ("Time :", time()-a)


a = time()
l = spark.read.option("quote", "").option("delimiter", "\t").csv('wikirank-fr.tsv')

c = l.sort('_c1').count()
print ("Count :", c)
print ("Time :", time()-a)

a = time()
l = spark.read.option("quote", "").option("delimiter", "\t").csv('wikirank-fr.tsv')
c = l.sort('_c1').show()
print ("Count :", c)
print ("Time :", time()-a)