h********g 发帖数: 496 | 1 面经就发在同一个thread吧
这是个back to back两小时的面试,两轮的流程都是先问了些简历的东西,然后对方介
绍下自己的项目,然后coding。
1. coding题很简单,可能是半research职位,所以coding要求不高?
1) 给一堆document, d1, d2, d3...dn,要求给出 reverse-index: <{word1,
frequence1}, {word2, frequence2} ...>
---document很多,reverse index没法都放在内存里头,所以讨论了下如何partition
---还讨论了下不同document的类型,word之间的delimter可能不同,document预处理等
2) find lowest common parent for two nodes in the tree.
follow question: what's your test cases?
3) print tree nodes in level order
2. machine learning 的题目: 你有很多customer... 阅读全帖 |
|
y****w 发帖数: 3747 | 2 that is whi i asked. replacing is wrrong. they come from youe client who
typed enterr in the input area. replacing combine all lines and bhange the
data. you should find some other delimter or find some opttion which allow
char del takes higher priority. |
|
B*****g 发帖数: 34098 | 3 从java端传1|2|3|4.....,然后在oracle里parse后loop。 |
|
|
r***y 发帖数: 4379 | 5 没发现任何好处. 唯一的原因大概是developer不知道怎么传 collections , db
developer 也不知道怎么定义和处理这种类型.
一般legacy project巨多这种东西 |
|
g*****g 发帖数: 34805 | 6 在Oracle里parse/loop? stored procedure?
看数组多大,大数组俺一般直接serialize成blob,扔进去了事。
小数组这么做是有好处的,直接看DB方便。 |
|
B*****g 发帖数: 34098 | 7 db developer会,而且告诉java developer怎么做。 |
|
B*****g 发帖数: 34098 | 8 为啥扔blob不扔clob?
啥叫直接看DB方便? |
|
g*****g 发帖数: 34805 | 9 所有的java object都可以序列化成byte array,显然应该blob。
数组都是java object。看DB方便就是开发测试的时候,直接
用任何SQL客户端就能看到结果了,byte array不直观。 |
|
B*****g 发帖数: 34098 | 10 为啥要送java的object不送oracle的object? |
|
r*****s 发帖数: 985 | 11 i think this is what goodbug means:
@Lob
@Column(name = "SOMETHING")
private byte[] serializedSomething;
@Transient
private Something something;
public setSomething(Something details) {
serializedSomething = serializeSomething(details);
}
public Something getSomething() {
if (something != null) {
something = deserializeSomething(serializedSomething);
}
return something;
} |
|
r*****l 发帖数: 2859 | 12 1, It works.
2, It's pure data.
3, It's simple to understand.
4, It has small overhead. |
|