Hello, I was looking for an e-commerce Clickstream dataset and found yours Clickstream Example, that looks exactly what I needed.
I tried to download it, following this topic:
https://community.vertica.com/vertica/topics/where_is_the_clickstream_example?topic-reply-list%5Bset...
but it appears it's no longer available.
I was wondering if you could please provide me the DB?
I intend to use it in an academic project, and that leads me to my next question, are there any conditions/limitations of use?
Best regards,
Gabriel Mota
ClickStream Example
+2Hi Gabriel,
I reposted the file that Mark had received in the same location.
site customers.ftp.com
user ForumExchange
pwd tznjviZ2
the file name is ClickStream_Example.tar.gz and it's ~650k in size.
A couple comments he passed along in case they are of help:
FYI, the C++ files in these examples need to be edited so that main() returns int, or it won't compile. At least not with g++ on my Mac.
The SQL worked perfectly against MySQL by the way, though the date format in
Date_Dimension.tbl is %m/%d/%Y and should be %Y-%m-%d. I haven't tried changing Time.txt yet to work around this.
Regards,
I reposted the file that Mark had received in the same location.
site customers.ftp.com
user ForumExchange
pwd tznjviZ2
the file name is ClickStream_Example.tar.gz and it's ~650k in size.
A couple comments he passed along in case they are of help:
FYI, the C++ files in these examples need to be edited so that main() returns int, or it won't compile. At least not with g++ on my Mac.
The SQL worked perfectly against MySQL by the way, though the date format in
Date_Dimension.tbl is %m/%d/%Y and should be %Y-%m-%d. I haven't tried changing Time.txt yet to work around this.
Regards,
Thank you Steve.
I have download it, from ftp://ftp.vertica.com/ since the site you provide was not valid.
What about my second question? Could you please provide me some information, about the terms of use or limitations, regarding this DB?
I have download it, from ftp://ftp.vertica.com/ since the site you provide was not valid.
What about my second question? Could you please provide me some information, about the terms of use or limitations, regarding this DB?
+2Gabriel,
I'm confirming with Sales but I do not believe there are any restrictions, limitations, terms of use of the Vertica example dbs such as VMart or ClickStream. They are provided as examples and I wouldn't think there would be any restriction on a customer using them as a basis to build upon. As noted I'll confirm this with Sales and post the final word on it.
I'm confirming with Sales but I do not believe there are any restrictions, limitations, terms of use of the Vertica example dbs such as VMart or ClickStream. They are provided as examples and I wouldn't think there would be any restriction on a customer using them as a basis to build upon. As noted I'll confirm this with Sales and post the final word on it.
+2Hi Gabriel / Steve
The site ftp://ftp.vertica.com/ - Is it publicly available.
If yes what is the username and passwd for this .
Thanks
The site ftp://ftp.vertica.com/ - Is it publicly available.
If yes what is the username and passwd for this .
Thanks
+2Navin,
I don't believe that ftp.vertica.com is accessible from everywhere, but the aforementioned customers.vertica.com is. The customers.vertica.com site doesn't allow browsing for security reasons, so you have to have a specific id/pwd combination to get to content. In this case the clickstream example is at:
site customers.ftp.com
user ForumExchange
pwd tznjviZ2
I don't believe that ftp.vertica.com is accessible from everywhere, but the aforementioned customers.vertica.com is. The customers.vertica.com site doesn't allow browsing for security reasons, so you have to have a specific id/pwd combination to get to content. In this case the clickstream example is at:
site customers.ftp.com
user ForumExchange
pwd tznjviZ2
+2Thanks Steve,
But I can only see a blank screen on http://customers.vertica.com/ . Its not even asking for credentials.
Thanks
But I can only see a blank screen on http://customers.vertica.com/ . Its not even asking for credentials.
Thanks
+2It's an ftp site so http won't get you there. If you don't have an ftp client you can try via your browser using url ftp://ForumExchange:tznjviZ2@customers.vertica.com. You may be prompted if you want to go to the site, say yes.
+2Thanks Steve...It worked.
Could you please re-upload all datasets, specifically clickstream one.
Can you please reupload the clickstream database? Thanks in advance!
Hi Steve,
Can you please reload the clickstream dataset again. Thanks in advance.
Thanks a lot for the data files.
It will be great if i can get the clickstream data files for any ecommerce website and that will help me a lot in my project.
Thanks in advance.
Hi
For POC developement, can anybody share the clickstream data?
Isaac
@Karthik_Manohar said:
Thanks a lot for the data files.It will be great if i can get the clickstream data files for any ecommerce website and that will help me a lot in my project.
I am also looking for a similar type of features for my ecommerce store. The store is created on Magento framework and is hosted on Cloudways powered Magento hosting.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
